Removed (posted twice somehow)

We dyed the Chicago River Cubs blue.

Another way (building off Drew and Kevin's excellent solutions) would be like this:

WITH iTally(n) AS

(

SELECT n

FROM ( VALUES(1), (2), (3), (4), (5), (6), (7), (8),...

I missed the article the first time around but just read it.

The fact that SSIS packages are XML files makes documenting SSIS so much easier provided you have a...

Luis Cazares (11/2/2016)

---

Why do you even need a derived table?

SELECT

meetingID,

ProviderName,

SubGroupName,

SessionName,

...

I use query hints from time-to-time (not too often) but only when there is no doubt that it's the right choice. The conventional wisdom seems to be that, if you...

thomashohner (11/2/2016)

---

I think i figured it out. Ugly SQL but it seems to work.

Thanks

--Meeting, Subgroup, Session

CREATE TABLE #Table (MeetingID INT , Levels VARCHAR(20), ProviderName VARCHAR(20), PatientName VARCHAR(20), SubGroupName VARCHAR(20),SessionName...

jasona.work (11/2/2016)

---

So, any bets on how much of Chicago will be left standing after tonight, if the Cubs win (or lose?)

I'm thinking something along the lines of when the Detroit...

This is an interesting 5-year old thread...

Something interesting to note is that the default output for the SQLXML value method is all child text. With that in mind, this...

Markus (11/2/2016)

---

This last game could go either way... I was looking this morning and both teams have scored 19 runs each in these 6 games.

Kluber is their best...

academy

mickegohle (11/1/2016)

---

Hi all,

I have tried to get an insert query to execute faster.

I have a table with an xml-column in it. This xml is quite big and there are...

Here's kind of a hybrid of both of Luis' solutions:

let's say you have a maximum number of delimiters, for my example we'll say a max of 6 (but you...

djj (10/24/2016)

---

Alan.B (10/22/2016)

---

Alan.B (10/14/2016)

---

Ray K (10/14/2016)

---

Tried to stay up last night to watch Dodgers vs. Nationals Game 5. I made it to the 8th inning before I finally gave...

Alan.B (10/14/2016)

---

Ray K (10/14/2016)

---

Tried to stay up last night to watch Dodgers vs. Nationals Game 5. I made it to the 8th inning before I finally gave up and...