Hi,

Yes, the report is run on demand around the beginning of each month by an end user on the Report Manager. I've tried emailing it to myself and tried...

Hi Jeff,

I don't think it matters. That column was more for illustration to help make clear the issue. The numbered column provided was sufficient for the business needs.

Thanks,

Matt

I don't have any questions. Thanks for asking. I actually already got feedback from the biz and that's exactly what they were looking for!

Pretty sure you're my hero now Wayne..Thanks so much for your help. That definitely worked and is exactly what I'm looking for!

CTE Query:

CREATE TABLE #Temp1

(ID INT, Code VARCHAR(4))

INSERT INTO #Temp1

VALUES

('1','1510'),

('1','1515'),

('1','1520'),

('1','1525'),

('2','1510'),

('2','1515'),

('2','1520'),

('2','1525'),

('3','1510'),

('3','1580'),

('4','1510'),

('4','1590')

;WITH CTE AS

(

SELECT DISTINCT ID

FROM #Temp1

)

SELECT

ID,

...

Hi,

Thanks for the reply! What I want to see is this (sorry Excel doesn't copy over very well):

IDCodeGroupingGroupingOther

115101A

115151A

115201A

115251A

215101A

215151A

215201A

215251A

315102B

315802B

415103C

415903C

The "Grouping" or "GroupOther" columns identifies all the different code sets and...

This comment helped remove the server list. Thanks.

Bad news, but thanks for the direction...

That worked! Thanks. And the script is pretty darn awesome!!!

I think this script will be extremely useful, but are you sure it works? I have AdventureWorks running on a SQL 2008 box, and I copied and pasted the...

That's exactly what I'm looking for, thank you.

Hmmm, I'm not sure I follow. Can you please identify where in the query I would add this syntax? I've tried in multiple places, but the final results...

Blank is fine. In fact, the reason I put "Blank" in there at all is because it didn't work when I just used a space (' ').

What...

Beautiful, thanks!!!! That works too!

Conceptually, I think I have it. Thanks for the replies guys!

/*******************************************************************************************

Creates temporary Order Table for example

*******************************************************************************************/

create table #Orders

(

...