Good QotD. Someone not knowing this could introduce a serious bug into their work.

glebih (10/17/2016)

---

Assuming that an UPDATE statement effectively DELETEs and INSERTs a record, can the values not be retreived via OUTPUT ?

IE

UPDATE table

SET Col1 = Val1

OUTPUT inserted.Col1 (should be Val1),...

>> I have to check if this exists in table, if it does not exist only then insert. <<

No, another alternative is to try to insert a row and see...

Just to note, for the answer that you marked as correct ... the second instance where col1=2 has col5 = 'ewqq' and not 'kjhg' as you specified. Eirikur's solution however...

You'll have to provide some more information like the...

Building on Lynn's good example here:: I added a couple of audit fields that you may readily see , 'created on' and 'updated on' dates. It is not difficult...

I believe in the one source of truth, as the ideal. From many sources one place to store. It also keeps enforcement on data standards easy since you are working...

bheema.ece12 (11/13/2016)

---

Have given all types of permissions, but no luck. Can someone help in resolving the error?

Error: [SSIS.Pipeline] Error: Read From CSV failed the pre-execute phase and returned error code...

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...