If you need to progamatically access a control on your report then use the following expression [csharp]ReportItems!textbox1.Value[/csharp]
SQL Server Print Logging in TSQL / Stored Procedures
In tsql when running stored procedures you may wish to output debug statements. The problem is that in a long running tsql the “Print” statements […]
SQL Server Print logging message function
I use this to log duration information when I am writing stored procedures with long running code.I find this useful when testing how long things […]
SQL Server Performance Testing
When attempting to assess the performance of a given script on SQL Server it is quite difficult. The caching of execution plans etc etc, lead […]
Case Sensitive T-SQL (TSQL) variables
I had an interesting problem the other day. Someone ran a sql script I had written on their SQL2005 database and it threw an error […]
SQL 2005 Unpivot Query
The other day I had need to use an unpivot query in SQL 2005. Thought it was really cool so here it is… Assume you […]