Experts I'm developing some SSRS reports for the office and I'm trying to feed a string parameter from my SSRS report @Year (i.e. '2010') into a MS SQL statement to get a resultset of records for i.e. “2010”. “Indate” is the datetime field I need to compare the string parameter data to to get a resultset of just invoices for example '2010'. What functions and syntax should I use? Can you help our here? Thanks in Advance.
SELECT CustSelCode, ExtPrice, ORep, InDate
WHERE ????? What function and syntax here?