SQL Saturday 97 Slides and Code – EXCEPT, INTERSECT, APPLY
Download my slides and source code from my SQL Saturday 97 presentation. Continue reading SQL Saturday 97 Slides and Code – EXCEPT, INTERSECT, APPLY
Browsing Category
SQL Blogs
SQL and SQL Server database topics. Includes design, issue resolution and tips.
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 Continue reading Incorrect Syntax Near go revisited
Find your SQL Server Profiler Template Path
Learn where SQL Server Profiler saves your Templates. Continue reading Find your SQL Server Profiler Template Path
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. Continue reading Display a Page Count in SSRS
Display results Horizontally in SQL Server
We are all familiar with seeing our data in a vertical format from SSMS. Here is a sample:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
SELECT * FROM #EmployeeJobs Employee_ID Job_id 100 500 100 501 100 502 100 503 100 504 191 501 191 502 191 503 191 505 188 503 188 504 |
But what if you, or your customer want’s the data horizontally? That is easy enough with a CTE. Continue reading “Display results Horizontally in SQL Server”
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.
Continue reading “Working with Seconds in Excel”
Using datediff to display results as HH:MM:SS
Sometimes you just need hh:mm:ss
I ran into a case when I needed to display some results in the HH:MM:SS format. We all know and love DATEDIFF, which gives you whole number results. Using DATEDIFF, I was getting results like this:
|
1 2 3 4 5 6 |
-- Declare some variables for the requested timeframe DECLARE @START_DATE DATETIME DECLARE @END_DATE DATETIME-- Set the timeframe variables SET @START_DATE = '2011-01-01 16:00:00' SET @END_DATE = '2011-01-01 22:47:22' SELECT DATEDIFF(second,@Start_date, @END_DATE) AS Segundos |
|
1 2 3 4 |
Segundos 24442 (1 row(s) affected) |
Continue reading “Using datediff to display results as HH:MM:SS”