Dwain tried your code and works great on the example, however when i try it on all columns the resulting data is spread all over will have...

Thanks Dwain - will give it a try

i tried both Sean and Luis suggestions

On Luis's a got a timeout error on the query before i finished adding all the columns . There are 18 columns i...

thanks Luis - will try that too

Thanks Sean - will try it out ASAP

the customer wants to see the values of "lookup tables" (values in drop-down select boxes) in the application in one place...

thanks for replying Sean

create table #temp_test

(

PROGRAM varchar(30),

MARKET_SEGMENT varchar(50),

RESP_ORG varchar(12),

APPROVAL varchar(50)

)

INSERT INTO #TEMP_TEST

(PROGRAM)

values ('ABC')

INSERT INTO #TEMP_TEST

(PROGRAM)

values ('DEF')

INSERT INTO #TEMP_TEST

(PROGRAM)

values ('GHI')

INSERT INTO #TEMP_TEST

(PROGRAM)

values ('JKL')

INSERT INTO #TEMP_TEST...

--===== If the test table already exists, drop it

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

DROP TABLE #mytable

--===== Create...