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 ...
There are so many ways to integrate an SSRS report into your page that the biggest problem you'll face is deciding which one to use. Peter runs through all the solutions he can think of, including ...