SQL help

[wiskoththa]

danna kenek mata me data table eka palleha thiyena format ekata ganna run karanna ona query eka deepan machan

Table1

ID____Type______Payment______from_________to

1_____sal________1000________01-01-2011____31-01-2011
2_____sal________2000________01-01-2011____31-01-2011
1_____bon_______1500________01-02-2011____28-02-2011
3_____sal________3000________01-01-2011____31-01-2011


into this format


Table2

ID____sal_____sal.from_______sal.to_________bon____bon.from________bon.to

1____1000____01-01-2011____31-01-2011____1500____01-02-2011____28-02-2011
2____2000____01-01-2011____31-01-2011
3____3000____01-01-2011____31-01-2011

thnks

 

[wiskoththa]

 

[wiskoththa]

 

[wiskoththa]

 

[chint]

mata nam ba
type eke thiyena sal,bon column widihata ganna therenne na

 

[kosandpol]

table 2 has more columns.
From where does the additional data come from ?

 

[wiskoththa]

table 2 has more columns.
From where does the additional data come from ?

no additional data machan
'sal' kiyana type eken data thieyena ID ekakata 'bon' kiyana type ekenut data thiyenawanam
e data last 3 columns walata enna ona..
if not 'sal' type eke data vitarak pennanawa

 

[wiskoththa]

mata nam ba
type eke thiyena sal,bon column widihata ganna therenne na

 

[chathu_ac]

SELECT ID, CASE WHEN type = 'sal' THEN Payment END AS sal, CASE WHEN type = 'sal' THEN FromDate END AS sal_from,
CASE WHEN type = 'sal' THEN ToDate END AS sal_to, CASE WHEN type = 'bon' THEN Payment END AS bon,
CASE WHEN type = 'bon' THEN FromDate END AS bon_from, CASE WHEN type = 'bon' THEN ToDate END AS bon_to
FROM dbo.Table_1

 

[wiskoththa]

SELECT ID, CASE WHEN type = 'sal' THEN Payment END AS sal, CASE WHEN type = 'sal' THEN FromDate END AS sal_from,
CASE WHEN type = 'sal' THEN ToDate END AS sal_to, CASE WHEN type = 'bon' THEN Payment END AS bon,
CASE WHEN type = 'bon' THEN FromDate END AS bon_from, CASE WHEN type = 'bon' THEN ToDate END AS bon_to
FROM dbo.Table_1

thnks alot bro
rep added

 

[wiskoththa]

SELECT ID, CASE WHEN type = 'sal' THEN Payment END AS sal, CASE WHEN type = 'sal' THEN FromDate END AS sal_from,
CASE WHEN type = 'sal' THEN ToDate END AS sal_to, CASE WHEN type = 'bon' THEN Payment END AS bon,
CASE WHEN type = 'bon' THEN FromDate END AS bon_from, CASE WHEN type = 'bon' THEN ToDate END AS bon_to
FROM dbo.Table_1

a bit issue...

wt i required is

ID____sal_____sal.from_______sal.to_________bon___ _bon.from________bon.to

1____1000____01-01-2011____31-01-2011____1500____01-02-2011____28-02-2011
2____2000____01-01-2011____31-01-2011
3____3000____01-01-2011____31-01-2011

but methanadi podi awlak thiyenawa....

ID____sal_____sal.from_______sal.to_________bon___ _bon.from________bon.to

1____1000____01-01-2011____31-01-2011___________________________________
1_______________________________________1500____01-02-2011____28-02-2011
2____2000____01-01-2011____31-01-2011
3____3000____01-01-2011____31-01-2011