Tag Archives: Microsoft SQL Server

Using PIVOT on Dates in One Column

Suppose you have a table that contains Job ID, when it was started, and when the Job ended. Now you want the difference in days between when it was started …

Tags: , , , , , , , , , , , , , , , | Posted under Programming/Coding | Leave a comment

Change Links in SQL Objects when Cloning Production to Test

Let me say at least one time in this article…..”Backup your Database before running the created text file.” Ok, now that I have said that let’s talk about a problem …

Tags: , , , , , , , , , , | Posted under Programming/Coding | Leave a comment