SELECT * FROM table1 WHERE fieldStatus IN (@Status) AND (CASE WHEN @Status = 'Open' AND COUNT(@Status) = 1 THEN fieldDate >= GETDATE() END) I hope that makes sense. Anyone know how to test for a multi ...
I'm using a GAC-installed assembly as part of a Reporting Services (2005) report. The code does not need any permissions beyond execution. All it does it take today's date and calculate last week's ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results