I need to populate temporary table from a database table. The records of the table are somthing like this
Country Type Amount
------------------------------
Ind FNT 10
Ind FNT 9
Ind FGH 1
Ind Sales 50
Ind FGH 5
USA FGH 4
USA FNT 3
USA Sales 100
USA FNT 1
USA FGH 39
I want to creat a Temp table which would have one record for every county and type. for ex from above records i should have
Ind FNT 19
Ind FGH 6
Ind Sales 50
USA FNT 4
USA FGH 43
USA Sales 100
Thanks
Kiran Shankar
Country Type Amount
------------------------------
Ind FNT 10
Ind FNT 9
Ind FGH 1
Ind Sales 50
Ind FGH 5
USA FGH 4
USA FNT 3
USA Sales 100
USA FNT 1
USA FGH 39
I want to creat a Temp table which would have one record for every county and type. for ex from above records i should have
Ind FNT 19
Ind FGH 6
Ind Sales 50
USA FNT 4
USA FGH 43
USA Sales 100
Thanks
Kiran Shankar