i have a table which contains a datetime type column.
i want to create a stored procedure that gets a surtain month and year as parameters and returns all the rows with the date column in the month and year range i sent as parameter.
for example if i send as parameter year 2009, and month 2,
i will get all rows with theese dates: '2.1.2009' , '2.4.2009' , '2.8.2009 ....
all the rows from the passed month and year.
i tryed to write a select statement like this:
select * from Reports where UserId = @id and ReportDate like @month + '%' + @year + '%'
it doesnt work.
what am i duing wrong ?