Case statements advice - query case field?
-
Alan.B (8/13/2013)
learning_sql (8/13/2013)
Ha, it literally said "Reporting Services does not support CROSS APPLY".However I have just been playing around and when just typing the query it worked every time, I have now published the report and it is still working...maybe I made the message up.
Correct me if I am wrong but: you are putting this query in an SSRS dataset as text (ad hoc query). You need to put the query into a stored proc and then call the stored proc from the dataset. Other T-SQL commands that you can't use in an SSRS ad hoc query include INTERSECT and EXCEPT. Stupid Microsoft :crazy:
Anyhow, I would recommend always using stored procedures in your SSRS datasets. You will see much better performance, your code will be more manageable and re-usable.
These are the things I can only learn on here - I'll remember that for the future.
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply