Monthly Archives: June 2013

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

Pivoting weird data in SSIS – Sort of…

Posted on June 17, 2013 by MikeDavisSQL

Sometimes we get data in some bad forms. For example look at the below table: The names and the amounts are comma separated in two different columns. Let’s imagine we need to get this data into a table like the … Continue reading →

Posted in SSIS, Syndication | Tagged | Leave a comment

SSRS – Using a Parameter to make Dynamic Columns

Posted on June 10, 2013 by MikeDavisSQL

Multiple value parameters are a common tools used in SSRS. You can use this tool to select which columns actually show on a report. You will need to create a multiple value parameter and place an expression on each column … Continue reading →

Posted in SSRS, Syndication | Tagged | 6 Comments

AS400 Program from SSIS

Posted on June 3, 2013 by MikeDavisSQL

If you need to call an AS 400 program from an SSIS package this can easily be accomplished with an Execute SQL Task. This can be made even easier with two variables and an expression too. The AS400 program QCMDEXC … Continue reading →

Posted in SSIS, Syndication | Tagged , | Leave a comment