Here is my solution:

with basedata as (

select

rn = row_number() over (partition by ClientId order by case when AddrType = 'Billing' then 1

...

Ed Wagner (8/3/2016)

---

Lynn Pettis (8/2/2016)

---

Well, add another to that list. CF is a pain, especially when the developers embed the SQL code in the CF code, and build it...

adonetok (8/2/2016)

---

I knew how to link SQL server tables to Access via ODBC.

How to link Access database to SQL server so that I can view Access tables in SQL studio...

Ed Wagner (8/2/2016)

---

jasona.work (8/2/2016)

---

Got to sort out a problem query this morning with one of the developers. Was rather interesting, initially tossed a couple indexes on a table (clustered...

If your original letter specified work at will and nothing in writing has superseded that statement, I would say you are free to give two weeks notice. No, the...

Brandie Tarvin (7/28/2016)

---

ChrisM@Work (7/28/2016)

---

BrainDonor (7/28/2016)

---

I would like to know why they even bother.

How many people out there are going to think "I could do with a new kitchen, where should...

SeniorITGuy (7/26/2016)

---

Sqlenthu,

A simple answer for you is to check the SQL instance out right away.

Brent Ozar has a great, free tool for this: spBlitz which can be downloaded here: [/url]

You...

Sean Lange (7/27/2016)

---

jasona.work (7/27/2016)

---

Considering the latest response in that topic, I...

Sean Lange (7/27/2016)

---

Good luck. Perhaps if your post was a little more cordial and less demanding we could...

I just love people that want others to do their job for them.

Haven't seen the UK Kitchen spam in a while.

GilaMonster (7/25/2016)

---

Lynn Pettis (7/25/2016)

---

GilaMonster (7/25/2016)

---

No, because what if there's 6 rows that need inserting and 4...

GilaMonster (7/25/2016)

---

No, because what if there's 6 rows that need inserting and 4 updating? To use...

fergfamster (7/25/2016)

---

Guys-

I have a table with 23 billion rows so Merge is out, as it scans the entire thing and has become a hog. So I'm going back in time...

Sean Lange (7/20/2016)

---

ThomasRushton (7/20/2016)

---

I don't think that...