It sounds like this would help: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url].

Drew

HappyGeek (7/11/2016)

---

drew.allen (7/11/2016)

---

Since all records within a partition necessarily have the same value for each field in the PARTITION BY clause, there is no reason to include any of those...

HappyGeek (7/11/2016)

---

I felt it was a bit odd that patients seemed to only exist in isolation and that another wasn't seen until the previous had completed treatment (so to speak)...

The two are equivalent and any XML parser should be able to handle either of them, so why "must" it be in the form "<tag></tag>"? In fact, "<tag/>" is...

Sergiy (7/7/2016)

---

drew.allen (7/7/2016)

---

Actually, I did provide my...

The Dixie Flatline (7/7/2016)

---

Drew, that sounds like the answer to a maiden's prayer, and I'd like to remember it for future reference, but after reading your note I looked at...

The Dixie Flatline (7/7/2016)

---

I'm not...

If you change your INSERT to a MERGE, then you can just OUTPUT the original GUID. Of course, the MERGE introduces it's own problems.

Drew

Part of the problem is that you are conflating table properties with row properties. When you are using sys.tables and sys.columns, you are looking at table properties, but when...

Actually, I did provide my rationale, but...

My fourth was busy. There was the Fun Badge Tour (dancing at various tourist attractions: the Gay Village, The Royal Ontario Museum, Toronto City Hall, Younge-Dundas Square, and Sugar...

jasona.work (6/30/2016)

---

So when September rolls around, I'm going to a convention in Toronto, Ontario (Canada,) FanExpo. It's a Comic book / movie / anime sort of convention, and they've...

That's the way JOINs work. You get a record for every match; so if each of four records matches two records, you will get eight records. If you...

Sergiy (6/29/2016)

---

drew.allen (6/29/2016)

---

I disagree....

I disagree. CAST...