Hi Martin

Please don't take this the wrong way - we all have to learn somewhere. The query you posted is about as simple as it can get. Buy yourself this...

Hide the beer quick lads...HR's doing the rounds

Not really. It's this one which got me thinking about it, because the data looks very familiar and also because the OP doesn't appear to know what he/she's doing and...

"How about them Bears?" 🙂

Is it just me, or are the posters who appear to be the students, the ones who have the nerve to post their homework here, the...

Paul White (3/2/2010)

---

Chris Morris-439714 (3/2/2010)

---

You're welcome. This one's a cracker too. Do you mind if I pass it to a colleague here? And if that is ok with you, what...

You're welcome. This one's a cracker too. Do you mind if I pass it to a colleague here? And if that is ok with you, what...

Paul White (3/2/2010)

---

Ha! Has it been chilly in H€ll recently then?

On a...

Paul White (3/2/2010)

---

Chris Morris-439714 (3/2/2010)

---

Hey Paul, guilty as charged. It's going to be thursday evening before I can give the article the time it deserves. Reading it on the train...

Paul White (3/2/2010)

---

Thanks Jason. I think it's pretty much ready for publication now, just waiting for the last couple of reviews to come in (hint...

Thank you Pritesh, this is very helpful.

The first part of your UNION query looks like this:

Select CandidateID as ID, '0' as Exp, Status

from @CandidateUsedForProject

where ProjectId in (Select a.ProjectId...

What time do the pubs open where...

Hi Pritesh

It's not obvious what you are trying to do, but let's have a go anyway. The first thing to do is to break your problem down into separate parts,...

RBarryYoung (4/4/2009)

---

Ramesh (4/4/2009)

---

Barry,

Well, I know it can easily extended to the next or higher level by adding another REPLACE of 9 commas or even 11 commas, but I just wanted...

Thanks 🙂

Jacco

Assuming there are no gaps in your identity column:

;WITH Results AS (

SELECT pkId, Col1, Col2, Col3, Col4

FROM dbo.tblDemo

WHERE pkId = 1

UNION ALL

SELECT s.pkId,

ISNULL(s.Col1, r.Col1),

ISNULL(s.Col2, r.Col2),

ISNULL(s.Col3, r.Col3),...