-
Incorrect Syntax Near go revisited
Incorrect Syntax near go. We’ve all gotten this error before, but why does this happen? Watch a video explaining why you cannot use GO inside of sp_executesql
-
Display a Page Count in SSRS
Learn how to add a date printed and a page count in the footer of your SSRS report. Even if you have errors with Globals!OverallTotalPages.
-
Display results Horizontally in SQL Server
Learn how to use SQL Server’s CTEs to display results in a horizontal format instead of the standard vertical format.
-
Working with Seconds in Excel
I recently had to use back end data from SQL Server to deliver several reports in excel. All of my SQL code gave me results in seconds; however, the users had distinct formatting requests. I would have to use a few excel tricks to get things just right in each report.
-
Using datediff to display results as HH:MM:SS
DateDiff is a great tool in SQL Server. But you have to extend DateDiff a bit to get things in a nicer format, such as HH:MM:SS. See what Rudy found on SQLServerCentral.com which saved the afternoon!