CirquedeSQLeil (9/15/2010)

---

Brandie Tarvin (9/15/2010)

---

[font="Verdana"]We're sorry. The user you are attempting to contact has been smited for biltong blasphemy. Please try your post again later.[/font]

[font="Verdana"]We're sorry. The user you are attempting...

Brandie Tarvin (9/15/2010)

---

GilaMonster (9/15/2010)

---

Chris Morris-439714 (9/15/2010)

---

Paul White NZ (9/15/2010)

---

Don't know. But I...

Paul White NZ (9/15/2010)

---

Don't know. But I do know what an expired...

wiggles

It's really inefficient code. Try this:

INSERT INTO #dgclassNew (eqpid, book_no, flag, dgclass)

SELECT d.cno, d.bno, d.flag, iTVF.dgclass

FROM @dgclassunique d

CROSS APPLY

(SELECT CAST(dgclass AS VARCHAR) + ','

FROM @dgclassunique

WHERE cno =...

Tom.Thomson (9/15/2010)

---

Stefan Krzywicki (9/14/2010)

---

CirquedeSQLeil (9/14/2010)

---

Alvin Ramard (9/14/2010)

---

GilaMonster (9/14/2010)

---

Grant Fritchey (9/14/2010)

---

GilaMonster (9/14/2010)

---

Lynn Pettis (9/14/2010)

---

The key to arguing with GilaMonster (or anyone for that matter) is:

A) Admit when you are wrong.

B) If...

ilbric-762008 (9/15/2010)

---

Well, simply perfect!!

Actually I have a question... could you explain the following row, the first in the CTE statement?

SELECT [ColumnName] =...

If you're unsure about any part of this, just ask 🙂

-- sample data (not part of the solution)

DROP TABLE #Sample

CREATE TABLE #Sample

...

There are numerous ways of getting the aggregates that you need, but how do you expect the output to look? If you run this, then you'll see what I mean:

DROP...

I tried a slightly different tack, thinking that perhaps the conditional was screwed by the lack of a BEGIN-END block around the TRY-CATCH:

DECLARE @Splitter BIT

SET @Splitter = 1

IF @Splitter =...

Why get bored and give yourself a headache when you could be having fun?

Will The Thread be affected by the steeply-rising cost of cotton? Maybe...just a bit? 😀

Left join table B to table a. Nothing could be simpler.

@steve-2: I don't know about you but I'm totally lost.

Please edit the following code so that the values exactly match your table:

IF OBJECT_ID( 'tempdb..#MyTable') IS NOT NULL DROP TABLE #MyTable

CREATE TABLE #MyTable (PeriodDescription VARCHAR(20))

INSERT INTO #MyTable (PeriodDescription)

SELECT 'Q1 2009'...