Sql Query Help - Urgent

[Diana]

 

 

nissan kuda nenu pettindi confirm chesadu ante nenu correct ga google chesa anega 

super  S#d^  naku oka mukka kuda q telekapoyina correct ga ans find out chesa   S#d^

[150bryant]

nissan kuda nenu pettindi confirm chesadu ante nenu correct ga google chesa anega 

super  S#d^  naku oka mukka kuda q telekapoyina correct ga ans find out chesa   S#d^

are u forever alone good google searcher diana?

[Hyderabad_Nawab]

PIVOT

+1.... Use pivot : Google karo.. Neeke artham Ayitadhi...Easy e...;)

[Hyderabad_Nawab]

nissan kuda nenu pettindi confirm chesadu ante nenu correct ga google chesa anega
super S#d^ naku oka mukka kuda q telekapoyina correct ga ans find out chesa S#d^

Ori née Self Dabba Eshaaalooooo....

[Tadika]

LTT HELP

[Diana]

are u forever alone good google searcher diana?

:3D_Smiles:

[Bairagi From Bapatla]

thnQ all

[Diana]

Ori née Self Dabba Eshaaalooooo....

lol sometimes it is better  @3$%

[bowne1980]

Try this.

 

create table a(

ID int,

answer char(5))

 

insert into a(ID,answer) Values(1,'Yes')

insert into a(ID,answer) Values(2,'No')

insert into a(ID,answer) Values(3,'Yes')

 

 

 

 

select * from 

(select 'ID'+''+Cast(ID as Varchar) as ID,answer from a) as Src

pivot(Max(Answer) for ID in([ID1],[ID2],[ID3]))

as PvtTable

[MeetFriendz]

ok

[Diana]

 

Try this.

 

create table a(

ID int,

answer char(5))

 

insert into a(ID,answer) Values(1,'Yes')

insert into a(ID,answer) Values(2,'No')

insert into a(ID,answer) Values(3,'Yes')

 

 

 

 

select * from 

(select 'ID'+''+Cast(ID as Varchar) as ID,answer from a) as Src

pivot(Max(Answer) for ID in([ID1],[ID2],[ID3]))

as PvtTable

 

postullev kotha answers post cheyadallev  @3$%

 

 

[Tadika]

LTT

[150bryant]

:3D_Smiles:

 

 

lol sometimes it is better  @3$%

 

 

postullev kotha answers post cheyadallev  @3$%

endhi full josh lo unav?

[Diana]

endhi full josh lo unav?

night nidra ledu ipudu job ledu inkem migilindi josh tappa  :police:

[150bryant]

night nidra ledu ipudu job ledu inkem migilindi josh tappa  :police:

nidra ledhaa...

vu vu ..story pls