SSCrazy, yes. I actually friend my brain too early today I think. I just realized that the mastercustomer column had the data I wanted not the CUSNO column....

ok, can you see what I am after though? maybe I am both asking the wrong question and trying the wrong code.

in this scenario, the customer has a master...

I should point out that I do realize that the CUSNO '00001' that is missing is only in the mastercustomer column so the inner join of y.mastercustomer = x.customer is...

if OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

DROP TABLE #mytable

go

create table #mytable

(

cusno char(5),

mastercustomer char(5)

)

go

insert into #mytable

select '00002','00001' UNION ALL

select '00003','00002' UNION ALL

select '00004','00003' UNION ALL

select '00009','00008' UNION ALL

select '00010','00009'

go

with thelist (CUSNO, mastercustomer,...

I have attached a really rudimentary chart I made in excel to visually demonstrate. The 'K's are know values and the 'x's are a few examples of the numbers...

Thanks for the suggestions.

I am actually using a table right now. A weekness is that I get many requests for 'test' plans with different scales that are derived from...

this is true for virtualization and I suspect also quite true for sql.

The use of multiple cores and the resulting performance depends on these factors.

1) how can the execution be...

lutzm, Just throwing out anther thanks here, I now live and breath tally tables. I have been converting views that have always been slow to use the tally table method...

I actually need to UNPIVOT the CSV values instead of PIVOT them. The real difficulty I am having is the where clauses right now

Thanks! I was able to adapt this to my needs. Very interesting read on the Tally tables too!

Thanks for the response Lynn. I did some math and unfortunately, normalizing this data is not an option.

This table functions as a filter for location, branch, route, delivery method,...

LutzM, that other thread you have posted in I started is an attempt at doing just that. But, I have a bunch of columns that are in the csv-value...

I should add that the table AWGCustom.dbo.COMS_PAYTABLE has more fields that I am using in this query. I just dont need them now so I skip them.

the actual query. the Com* columns added together are the key, I add a ',' and attach it to salnum which is the CSV value. If I put...

since I already have a table to use, how can I put that in place of

DECLARE @test-2 TABLE (id INT, val VARCHAR(100));

INSERT INTO @test-2

SELECT 1,'jack,25,A67,91J,67,99'...