Thank you all for the valuable insight. I totally missed that comma...guess I had been looking at it too long :-).

Have a good day!

Thanks, Lowell. Your response was helpful...I know it's something that may have been obvious, but I just wanted to verify. 🙂

Hi All,

Thanks for your assistance. It turns out I was taking the wrong approach with this query....so until next time... 🙂

Sean Lange (7/17/2013)

The problem here is that we can't...

Just edited the query at the beginning of the thread to include the On criteria, but still no progress...any thoughts, anyone?

I believe the output would give me the dupe records that I'm wondering about. Am I mistaken to think so?

The columns that are in the order by: ClaimId, LineNum, EncounterLineNum, EncounterType, and InternalICN. These make up the primary key that results of both queries are being inserted into in...

Chris,

What I'm trying to get from this query are records that are in common to both subqueries. This would tell me which records are responsible for the duplicate error I...

Hi Hanshi,

Actually, originally the group by was part of the 1st subquery, but it wasn't working, so this is why I tried placing it at the end, but obviously it's...

Hi Chris,

Sure, I'd be happy to provide more detail. So the results of both queries are being inserted into the same table as part of a longer stored procedure, which...

I'm having a similar issue...can anyone please advise?

Thanks for your suggestion. It actually turns out that it was an issue with the configurations not pointing to the development server...all is well now!

Thanks again! 🙂

Hi,

I don't believe that the database was restored issue and when I considred the auto_fix, there are no orphaned users being shown. Any other suggestions would be greatly appreciated. Thanks!

Hi All,

I'm getting a similar error, "[Execute SQL Task] Error: Executing the query "Truncate Table Outcomes.ExtractTrackingTempTrunc..." failed with the following error: "Cannot find the object "ExtractTrackingTemp" because it does not...

Hi Lowell and All,

I appreciate your input. I see what you're saying by how there's no "Select * From", but what I have is a union, so I'm not sure...