Do you want table 1 to end up exactly matching the contents of table 2?

If so you want to update the existing row then do an insert selecting matching rCde,...

Yeah, they are from totally different parts of a query. DISTINCT is part of the select clause and IN part of the where clause.

Some performance points though could be...

If you...

After much thinking I pondered the possibility it was a corruption in the encryption keys. The symmetric keys for reporting services had become corrupt after a power outage some time...

It was working for a long while.

SSIS back end functionality is present in workgroup. What is not present is the custom package management tools. Maint tasks and manual imports are...

Do you have a table structure sample? Is there a unique ID on the main table? Is this sql 2k or higher?

It's Friday I can't be bothered with real work so i thought I'd give this a few minutes. the ROW_NUMBER stuff is one of the most useful things I have...

I am having the same issue. I used to have a working maintenance plan but it started failing ages ago. I have been a tad lax in looking at it...