Yes, it does, Sean. Thank you. I didn't thing of using TOP 1.

Good point, Sean. I am going to have to think about that one. I don't think there would be 2 or more proc dates with the same DayKey, but I...

Thanks for the reply. My query gives a single row. Yours gives me multiple rows. But my query has 2 objects in the FROM clause instead of a JOIN, joining...

Your solution seems like the one! Finally. Hopefully I can put this one to rest. I couldn't seem to get mine to insert the Target rows, anyway. I thought it...

Thank you for your response. While you were coming up with that, I came up with this as an entire solution finally. If you can, please take a look at...

I am struggling greatly to get the IN clause to work with a compound 2 column key. If you could help me get that, I think I may have it....

I have been struggling for hours to get this and I cannot figure out how to use the IN clause when there are 2 columns making up the primary key.

I tried this but it returned no results from either the target or the errors table and there were no errors returned:

--First insert the rows we know will fail

INSERT Errors

select...

This is really good so far. Thank you very much. I forgot to mention in the last post that holi_id is part of the primary key so I have to...

Thank you for your quick reply. I would just want to put them both into the error table, maybe even with a different error description. It's impossible to evaluate them...

Thank you very much - we are very close now. But what if there are duplicates in the source - not counting the target? How do we get those out?...

Thanks for the response. I finally got it. It is only scantily documented or explained as to what is happening here. The language is ambiguous. For example, if you create...

Thank you for these replies. They all give me some hints for my future endeavors. However, much I have to do is already scripted for me and I am just...

Actually, I figured it out and it works. Let me know if you see any pitfalls or improvements.

DECLARE @strReportDate VARCHAR(10)

SET @strReportDate = CAST(DATENAME(MONTH,GETDATE()) AS VARCHAR(10))

SELECT [InstNumber]

...