Sorry to disappoint you guys but I wasn't able to come up with anything.

My gut was telling me an rCTE wouldn't do it and the set-based loop I tried wouldn't...

Cadavre (5/13/2013)

---

I really don't have time to dig into this, work is a bet hectic. When I've got some spare time, I'll try to remember to revisit it. I'm...

Reeni-244464 (5/9/2013)

---

Hi

I'm a little late to the party. 🙂 and I'm a little confused - I have used merge in similar instances and it has behaved as was originally intended...

rocky_498 (4/22/2013)

---

Your query is good for sample data. However I have 3m rows in my database and i want, IF are same i want MAX(DATE). SO at the end My...

Late to the party it seems but I think what you need is a good delimited string splitter like DelimitedSplit8K[/url] in the linked article.

WITH ComputerRecords (cn) AS (

SELECT 'Sys=Apple Inc.|iMac11,1;SN=QP0261H75RU;OS=Ver:6.1.7601,SP:1,Type:1;Form=Desktop;'

UNION...

Lynn Pettis (4/23/2013)

---

L' Eomot Inversé (4/23/2013)

---

Jeff Moden (4/23/2013)

---

Heh... to complicated. Just take Jason.A to work and let him entertain the kids with stories of GPO's as if they were...

Jeff Moden (4/16/2013)

---

ChrisM@Work (4/16/2013)

---

Thanks Jeff! And thank you for the encouragement to put pen to paper. DC's been nagging me for ages. Once...

L' Eomot Inversé (4/20/2013)

---

David Burrows (6/20/2012)

---

vinu512 (6/20/2012)

---

Cadavre (6/20/2012)

---

Well, I doubt I'd be the developer I am today (or have the job I currently have) without Jeff and a lot of...

ChrisM@Work (4/19/2013)

---

Sean Lange (4/18/2013)

---

patrickmcginnis59 10839 (4/18/2013)

Time and again I've read in the news folks absolutely ruin their own lives over dumb forum stuff even when posting under what they perceive...

Thanks Jeff.

Actually my latest only got 4 stars but on...

Jeff Moden (4/16/2013)

---

ChrisM@Work (4/16/2013)

---

Thanks Jeff! And thank you for the encouragement to put pen to paper. DC's been nagging me for ages. Once...

michaelhitchin (4/5/2013)

---

An interesting article, but IMO it would be even better if you stated what you wanted: "...to replace the entire block of records for ID=2" in the introduction, or...

Jeff Moden (4/7/2013)

---

amd.repetto (4/7/2013)

---

dwain.c (4/7/2013)

---

As a sidebar, that format is usually referred to as an "EAV",...

amd.repetto (4/5/2013)

---

Sorry, I post this as a new reply and I don't know how to delete it:

"Dwain,

Thanks for the quick answer! Don't worry, answer me when you have enough time,...

amd.repetto (4/5/2013)

---

Hi Dwain,

The post was very useful to me, I use it all the time!! just have little question, if you check the insert values statement on msdn, it has...