I'm sure you already know this but its worth mentioning. In your source control dont forget to create a tag for your releases so that you know what version of...

This would have given me the indication right away that there...

davoscollective (11/11/2016)

---

MMartin1 (11/10/2016)

---

If these do represent the source, think of the maintenance nightmare when the source changes, or another is added. This is not the way to...

Since you are unsure and want to implement a left join I easily recommend MERGE. The Lookup transform is a little different. Try reading more about them on MSDB. For...

ShinyK (11/10/2016)

---

By default, the Lookup operates as an INNER JOIN - but we need a LEFT (OUTER) JOIN. Click the "Configure Error Output" button to open the "Configure Error Output"...

If these do represent the source, think of the maintenance nightmare when the source changes, or another is added. This is not the way to design IMHO....

What is the rule if you have three people named Bo Derek, or four people named Joe Smith? In the prior code run I see that the last one...

Just a note, make sure the input streams are sorted in the same manner. I have seen where they were not and the data...

Assuming it is the 'Sick' hours that you are mainly focusing on , the following is as simple as I can code it:

selectcid,

sum(case when hr_type = 'sick' then 0...

Are you querying everything from one table or doing some type of join(s)?

Thanks Steve. Good straightforward question. I take it the capital Q means Quit (I'm not a sqlCmd user).

Ok maybe the defaulting of the bit field to 'false' is a little "bit" tricky. Part of the...

Ditto,

First name can be 'John' OR 'Linda' but cannot be both at the same time (which is what a AND condition is implying).

I figured B, though I was struggling with D and was glad that the options were this or not this rather than figuring out the math on D 🙂

This may not sound elegant, but a two step approach is to query out the entire xml string with the Results To File setting selected. Save the results to a...