Or use a CASE statement.

SELECT Col1, Col2,

CASE WHEN cte1.Col IS NULL THEN cte2.Col ELSE cte1.Col END AS MyCol

FROM ....

This assumes that you can join the CTEs to each other...

Siiiiiigggggghhhhh.

You would think when I get an alert that a log file drive is full in a non-prod system the first thing I would look at is whether or not...

Eirikur Eiriksson (12/16/2016)

---

Phil Parkin (12/16/2016)

---

Grumpy DBA (12/16/2016)

---

Wow, today's spam includes a warning about BOOTY POP... dang, just as I was about to order cases of BOOTY POP for my family...

Beware the Twitter list. For it is a way of defining you and boxing you into a corner!

Actually, lists can be followed as a whole (I don't remember how) so...

JustMarie (12/13/2016)

---

drew.allen (12/13/2016)

---

Does any else think that this response borders on being unethical? http://www.sqlservercentral.com/Forums/FindPost1842475.aspx It sounds like she wants to use this approach just to avoid due...

Beatrix Kiddo (12/12/2016)

---

Do you have Vick's First Defence (First Defense ;-)) nasal spray over there? I find it quite good- not sure how scientific it is, but my theory is...

Gah. Less than a week until my parents visit for two weeks and I catch a cold. The last thing I need to do is give it to them because...

rodjkidd (12/9/2016)

---

ChrisM@Work (12/8/2016)

---

Oh poo....

Bare

Rifle

Sean Lange (12/6/2016)

---

Time for the annual voyage to a destination for my wife's holiday party. They really go all out!!! They always fly the employees to a location and pay...

Meander

Santa

I broached this issue to my coworkers. Turns out the system account owned all the folders in question, not allowing us to make changes to them via the install package,...

There will be A TEST!

😀