Hi,
I am trying to create a temp table in SQL Server 2000 from an existing table. The existing table has the following structure:
Transaction_ID Tran_Breakdown_ID Amount
0001 Net £25
0001 Tax_IPT £1.50
0001 Fee £15
The Net, tax_IPT and fee entries all relate to the same transaction. In a new table i want to display as follows:
Transaction_ID Net Fee Tax_IPT
0001 £25 £15 £1.50
I thought i would need to use a CASE expression to acheive this but i cannot get it to work. Is anyone able to advise?
Many thanks
Justin
I am trying to create a temp table in SQL Server 2000 from an existing table. The existing table has the following structure:
Transaction_ID Tran_Breakdown_ID Amount
0001 Net £25
0001 Tax_IPT £1.50
0001 Fee £15
The Net, tax_IPT and fee entries all relate to the same transaction. In a new table i want to display as follows:
Transaction_ID Net Fee Tax_IPT
0001 £25 £15 £1.50
I thought i would need to use a CASE expression to acheive this but i cannot get it to work. Is anyone able to advise?
Many thanks
Justin