Query Help

Last Post 29 Sep 2008 10:20 AM by GoodFella3993. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
GoodFella3993
New Member
New Member

--
26 Sep 2008 11:27 AM
I have a table:

REC_ID, 'A', 'B', 'C', 'D', 'E'
_1____, X, NULL,X,NULL,NULL,NULL
_2____,NULL,NULL,X,X,NULL,X
_3____,X,NULL,NULL,NULL,NULL
_4____,NULL,X,NULL,NULL,X
_5____,NULL,NULL,NULL,X,NULL

I am trying to write a query that transforms this table into 2 columns

REC_ID, 'ABCDE'

Where the REC_ID is repeating

REC_ID, 'ABCDE'
_1_____A_
_1_____C_
_2_____C_
_2_____D_
_2_____E_
_3_____A_
_4_____B_
_4_____E_
_5_____D_

Thanks,
Marc
GoodFella3993
New Member
New Member

--
29 Sep 2008 10:20 AM
Works Great. Thank You.
You are not authorized to post a reply.

Acceptable Use Policy