quote: Originally posted by chbala85 it's not geting my excepted answer.........
--your Sample dataDECLARE @tab1 TABLE(formid int, questionId int, question varchar(30), response varchar(30))insert into @tab1SELECT 444, 2170, 'DeclarantsName', 'jennay' union all SELECT 444, 2171, 'Declarantaddress', 'us' union allSELECT 444, 10200, 'Ido', 'pain' union all SELECT 444, 10229, 'want1', 'pain2' union allSELECT 444, 152, 'want2', 'pan3' union allSELECT 445, 2170, 'DeclarantsName', 'jennay1' union all SELECT 445, 2171, 'Declarantaddress', 'us1' union allSELECT 445, 10200, 'Ido', 'pain1' union all SELECT 445, 10229, 'want1', 'pain21' union allSELECT 445, 152, 'want2', 'pan31'--QuerySELECT formid, MAX( CASE WHEN question='DeclarantsName' THEN response END) AS DeclarantsName, MAX( CASE WHEN question='Declarantaddress' THEN response END) AS Declarantaddress, MAX( CASE WHEN question='Ido' THEN response END) AS DeclarantsName, MAX( CASE WHEN question='want1' THEN response END) AS want1, MAX( CASE WHEN question='want2' THEN response END) AS want2FROM @tab1GROUP BY formid/*OUTPUT:formid DeclarantsName Declarantaddress DeclarantsName want1 want2444 jennay us pain pain2 pan3445 jennay1 us1 pain1 pain21 pan31*/ tell us the exact requirement... As per your explanation & sample data the above query is working fine--Chandu |