I don't have 2005, so I could not try UNPIVOT, but it sure looks a lot better than my solution. Anyhow, I made a temp table with the column...

Karthik. Dude. Listen, its still not right. Your table has 30 columns, and your sample data only has 25 values. I...

Karthik, both your table structure and sample data have errors, at least when I copy and paste. You are trying to create a composite key on a nullable column,...

Karthik, I am talking about sample table structure and sample data with create and insert statements, so anyone trying to help does not have to guess, or spend time making...

Karthik, this looks like a prime candidate for a crosstab, but without sample data...

Garadin, your solution is exactly what I need to do. Thank you so much for your quick effort.

Greetings all. I posted this a couple of weeks ago, and did not get any bites, and subsequently it went away anyway, but now the request has come again,...

JJ, can you post your table structure with some sample data?

Yep, I finally got it. I was thinking that it would only work if the last digit were off by one, but I see now it will work regardless...

sweetdeal42, you are explicitly naming five columns in your insert statement,

insert into ##CreditCard (CCID, CardType, DiscRate, MidQual, NonQual)

but you are only selecting two. You need to either restrict...

What is someone fat fingers the first digit instead of the last, will it still work?

Arthur, I think there is another issue. If you have a customer id, say 600, showing...

Barry, what is the significance of the numbers in the IN group? If the ids are random, then couldn't the possibilies be endless? In light of the fact...

Arthur, try this

CREATE TABLE #test

(

CustID int,

id int

)

INSERT INTO #test

SELECT 500,1234 UNION ALL

SELECT 500,1234 UNION ALL

SELECT 600,1233 UNION ALL

SELECT 600,1232 UNION ALL

SELECT 700,1000 UNION ALL

SELECT 700,1000 UNION ALL

SELECT 800,2001 UNION ALL

SELECT...

One thing to note. You need to make sure there is a space between the end of each line and the double quote before the & _. Else...