Thanks for your help. But will this query partition the resultset by City? Meaning will I be able to see all of the Cities and Companies? Or will it...

What result are you aiming for, here?

This was a bit of a logic mind-bender! Try this and see whether it's any quicker:

SELECT *
FROM #TAttrib ta
WHERE ta.ClinicID IS NULL
     ...

I use both, but honestly, I have found SSDT (well insofar as I need it to make SSIS packages) really annoying to use. So much is embedded in cryptic...

Can you...

Hah, I knew it! Nice code, Drew – like you, I prefer the CTE version.

--Deleted

• This reply was modified 6 years, 10 months ago by Phil Parkin.

As you've been following the forum for a long time, you'll also know that it's considered good practice to provide sample DDL, data (in the form of INSERT statements) and...

This is a technique which I have read about, but never implemented, therefore I don't feel qualified to direct you to specific links. I'm just waiting for the opportunity to...

Imagine the two sets of tables are named A and B.

It's early morning on a new day, and synonyms are currently pointing at set A, which includes the day before...

How about using Jeff's favourite method, SYNONYMs?

Have two versions of all 500 tables, which are truncated/loaded on alternate days. Use synonyms to switch between them every day. Your 'no data...

I just know that Drew is going to post a really snappy solution to this one ... that's what usually happens after I post my overblown version. But here goes...

Please provide more sample data (as INSERTs) along with desired results for that data, which demonstrates what you are trying to say.

Your code works , if you place the columns as you want to see result ( as example i provided) , but if i place all the columns in...

If you are OK with locking/blocking while the transaction completes, I suggest you look into the possibility of using

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE