asked
LOOPING THE DATA
Hi I am new to SQL, I have a strange requirement to loop the data. I don't have any idea to do that. I have a table ![alt text][1] Can anyone has an idea to do it in T-SQL? Thanks in Advance [1]: /storage/temp/1572-sql_central_q.png
Use UNPIVOT get the desired result: DECLARE @Table TABLE ( STORE INT , PROD1 BIT , PROD2 BIT , PROD3 BIT ); INSERT INTO @Table VALUES ( 1, 1, 0, 1 ), ( 2, 0, 1, 0 ), ( 3, 1, 1, 0 ); WITH cteUNPIVOT AS ( SELECT STORE , PRODUCT , EXIST FROM ( SELECT T.STORE , T.PROD1 , T.PROD2 , T.PROD3 FROM @Table T ) AS L1 UNPIVOT ( EXIST FOR PRODUCT IN ( PROD1, PROD2, PROD3 ) ) as L2 ) SELECT T1.STORE , T1.PRODUCT FROM cteUNPIVOT AS T1 WHERE T1.EXIST = 1;
15 People are following this question.
