Category Archives: T-SQL

Make an SSIS package Delay or Wait for Data

Posted on July 21, 2014 by MikeDavisSQL

Packages can be scheduled to run at a time when you expect data to be in a database. Instead of guessing the time when the data will be in the database we can have the package look for data in … Continue reading →

Posted in SSIS, Syndication, T-SQL | Tagged | 4 Comments

Two Digit Dates in SQL – MM/DD/YYYY

Posted on March 10, 2014 by MikeDavisSQL

When creating dates or numbers as strings it is sometimes required to have two digit numbers. For example, instead of this: 3/1/2011 You want to see this: 03/01/2011 There is an easy way to do this using the Right() function … Continue reading →

Posted in Syndication, T-SQL | Tagged | Leave a comment

Standard Deviations with CTE in SQL

Posted on February 24, 2014 by MikeDavisSQL

I was working with a client recently getting the number of standard deviations a student was off the average number of suspensions. I accomplished this with two Common Table Expressions, (CTE). The first CTE gets the standard deviation and the … Continue reading →

Posted in Syndication, T-SQL | Tagged | Leave a comment

Comparing Previous Rows in SQL

Posted on June 24, 2013 by MikeDavisSQL

I had a client recently that needed me to get the direction a student’s GPA was headed on a regular basis. To do this I needed to get the last GPA record on the table and the previous GPA. The … Continue reading →

Posted in Syndication, T-SQL | Tagged | Leave a comment

IT Pro Camp Jacksonville 2012

Posted on June 20, 2012 by MikeDavisSQL

I spoke last weekend (6/16/2012) at the first ever IT Pro Camp in Jacksonville Florida. It was a great event with over 100 people attending. Breakfast and Lunch was provided with a great after event at Tilted Kilt. One of … Continue reading →

Posted in SSIS, T-SQL, Training | Tagged | Leave a comment

Execute Multiple 2008/2005 SSIS Packages with a T-SQL

Posted on February 16, 2012 by MikeDavisSQL

If you want to execute a set of SSIS packages in SQL Server 2008 or 2005, you can do this using T-SQL. First you will  need a table with all of your package names on it. Then a While loop … Continue reading →

Posted in SSIS, Syndication, T-SQL | Tagged | 6 Comments

Sorting a String as a Number with T-SQL and SSIS

Posted on January 23, 2012 by MikeDavisSQL

I was working on a Cube in Analysis Services for a client recently and needed to sort on a field that was a varchar but contained numeric data. I wanted to sort as if it was numeric. I could not … Continue reading →

Posted in SSIS, Syndication, T-SQL | Tagged , | 2 Comments