I'm trying to use some variables in a TSQL query and I know I'm screwing it up. However, is there a way to see the TSQL AFTER the "compiler" SQL Server Management Studio's query places the variables ...

It would be nice if t-sql had some simple array handling abilities. How do you handle that? Are you doing that in the report itself, or do you receive the data and then inside the sproc you split it ...

In this third in a series on working smarter with T-SQL, let's give the built-in sp_executesql stored proc a go. In my previous posts, I've described some methods for generating and executing T-SQL ...