Resources
Posts Tagged "SQL Server"
Check out all of the posts tagged with "SQL Server".
SQL Saturday 97 Slides and Code – EXCEPT, INTERSECT, APPLY
Download my slides and source code from my SQL Saturday 97 presentation.
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
Find your SQL Server Profiler Template Path
Learn where SQL Server Profiler saves your Templates.
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.
Find numbers within a string in Excel
Learn how to use excel to extract numbers from strings.
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.