SQLKnowItAll (1/31/2013)

---

dwain.c (1/31/2013)

---

Jared - I would be most...

Sean Lange (1/31/2013)

---

The real issue is that many of us (myself included) are visual people and having the table to work with makes it easier to see the issue. I...

I'd be interested in hearing how to do that too!

And most...

I'll be a sport and setup some data to show you how you can display contacts and phones as a delimited list:

DECLARE @Company TABLE (CompanyName VARCHAR(100))

DECLARE @Contacts TABLE (CompanyName VARCHAR(100),...

srienstr (1/31/2013)

---

I get the same results both ways, even for days with no guests of one gender or no guests at all.

CREATE TABLE #Guests (checkin date, checkout date, FullName varchar(50),...

Right! Works until you have more than 3 countries.

I prefer the crosstab query approach myself. Jeff Moden has a couple of nifty articles on the subject:

http://www.sqlservercentral.com/articles/T-SQL/63681/

http://www.sqlservercentral.com/articles/Crosstab/65048/

Part 2 (second...

Hello again DA!

QU is the fastest approach for running totals:

CREATE TABLE #t2

(StatDate DATE PRIMARY KEY CLUSTERED

...

If the two tables are exactly the same why do you need to find differences? 😀

Seriously though, what you could do is something like this:

SELECT *

FROM (

...

Jared - I would be most interested in...

ChrisM@Work (1/31/2013)

---

dwain.c (1/30/2013)

---

Scott - Can you explain this?

I understand that ordering may be an issue....

SQLKnowItAll (1/30/2013)

---

DiverKas (1/30/2013)

---

SELECT STUFF(( SELECT ''+A.data FROM (SELECT DISTINCT TOP 100 PERCENT data FROM #temp ORDER BY data) A

FOR XML PATH ('')),1,1,'')

Would that not work? I have found that...

Scott - Can you explain this?

I understand that ordering may be an issue. Anything...

Perhaps this will help you find the path?

;WITH Transcript (message) AS (

SELECT '20:32:12 [Rachel] Thank you for contacting Our Company. How may...

dwain.c (1/30/2013)

---

Has the world just come to an end and no one told me?

Overnight for me in Bangkok and I received not a single notification from SSC, not even from...

Yup. Although technically most experts would consider a recursive CTE a loop in disguise.

CREATE TABLE #Transfer

(

ID INT IDENTITY PRIMARY KEY,

OldKey INT,

NewKey INT

)

INSERT INTO #Transfer (OldKey, NewKey)

VALUES (1, 2)

INSERT INTO...