Comments in BIDS SQL

  • How do you get comments to stay in SQL statements within the Visual Studio BIDS? I've tried both -- and /* */ and neither stick when the designer re-parses the statement. It would be helpful to be able to keep comments in the SQL.

    Thank you, Doug

  • use stored proc's instead of SQL embedded in the RS definition

  • My comments stick all the time. However I usually write my queries in SSMS and then paste into the query window in SSRS. Usually I have to change the query to Text mode, so maybe it it the text mode that is enabling me to save commented code.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply