Most recent posts

0

Joining Tables That Contain NULL Values

As you can see we have two tables, with the same values. Joining on these tables is no problem at all.  Simple, right?  Well, take a look at what happens when we try to join on...

Calculate the Date of Previous Sunday 1

Calculate the Date of Previous Sunday

There are a number of ways that you can calculate dates using T-SQL.  A common practice is to find the first day of the week which can be accomplished easily by using the following...

0

Use SQL from the Command Line

More often than not an execute SQL task in SSIS will do the trick.  If not, then the data flow will accomplish whatever objective is set out.  Occasionally those can become cumbersome in a...

Control Flow vs Data Flow 1

Control Flow vs Data Flow

After my first day of SSIS training my boss walked into the office and said to me, “how was the first day of class”.  To which I responded, “great!”  Then asked me, “so what...

SQL UPDATE Using a Join 0

SQL UPDATE Using a Join

You may need to do an update on joined tables to get a more conditional update.  For instance, I have a Student table as well as an AcademicStatus table.  The Student table contains all...