From the tables above, how can you tell that it was Jim who missed the call?

What is the logic behind the Answered and CallEnded grouping window? Where does 12.14:30 come...

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

A materialised view, in my experience, is a view which has been saved/persisted to a table. This is often for reasons of performance, but could also be because the data...

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