create procedure sp_display_activity @loginid int, @date datetime
as
select * from LoginActivity
where [date] = @date
and loginid = @loginid
Im having difficulty returning values from my stored procedure
that accepts 2 parameters of "date" and "loginID". I get an
error msg "cant convert data type datetime to type int". I
would like to pass a date parameter of just 12/01/2004 or
12-02-2004 and ignore any timestamp data in the field.
Im new to sql server and dont know the syntax I need to use.
Can anyone help me? Thanks.
as
select * from LoginActivity
where [date] = @date
and loginid = @loginid
Im having difficulty returning values from my stored procedure
that accepts 2 parameters of "date" and "loginID". I get an
error msg "cant convert data type datetime to type int". I
would like to pass a date parameter of just 12/01/2004 or
12-02-2004 and ignore any timestamp data in the field.
Im new to sql server and dont know the syntax I need to use.
Can anyone help me? Thanks.