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

Paul White (2/22/2010)

---

Chris Morris-439714 (2/22/2010)

---

No, really! And you, Mr White, should write an article on APPLY. I'm learning tons from reading your recent posts and I'm sure I'm not alone....

No, really! And you, Mr White, should write an article on CROSS APPLY. I'm learning tons from...

GSquared (2/22/2010)

---

Questions seem okay right now. Some of the answers have been abysmal recently. I guess it...

Grant Fritchey (2/19/2010)

---

Chris Morris-439714 (2/19/2010)

---

SQL Server 2008 Query Performance Tuning Distilled

SQL Server Execution Plans

There's more than one copy...

SQL Server 2008 Query Performance Tuning Distilled

SQL Server Execution Plans

There's more than one copy here, and we're not...

APIJENA (2/18/2010)

---

Thanks ChrisM@home for the reply, but tab2 doesn't have 'city' column.

as mentioned in the step 2, I want to join, on city, records matched in step1 with those didnt...

Paul White (2/18/2010)

---

Chris Morris-439714 (2/18/2010)

---

It's a great answer and needed to be said on the...

It's a great answer and needed to be said on the thread.

phumlo1 (2/10/2010)

---

Hi All,

I have a table-- TableA which could be linked to either TableB or TableC. I want to join either of the latter depending on which one is...

The white paper won't be published...

Andrew Watson-478275 (2/9/2010)

---

Could be I'm just being thick (it wouldn't be the first time), but I don't follow how the DATEDIFF(hh,0,EventTime) can work.

select datediff(hh,0,'09 feb 2010 12:34:56') returns 965196

and select...

TheSQLGuru (2/8/2010)

---

I wonder if the OP realizes that he/she is open to still putting in a record that already exists without proper transactioning/locking, especially if they do it in a...

peter-757102 (2/8/2010)

---

Chris Morris-439714 (2/8/2010)

---

Nice work, Peter, but I'm curious - if a CTE doesn't generate any kind of intermediate result, then how might a recursive CTE work? Bear in...

peter-757102 (1/23/2009)

---

I understand your point of view as well as the theory you put forward as to why it might be different in case of my proof. Therefore I did...