I am writing a query to put in ssrs - the user is going to choose a year for a paramater - I want that paramater to be passed to the sproc
so I've declare @year datetime
set Year = '2009 -- for testing purposes
in the where i have
Datepart(year, invoice_date) = @Year
but this is not working - does anyone have any thoughts?
View Complete Post