|
suriyarupa
Starting Member
19 Posts |
 Posted - 03/22/2013 : 02:34:28
|
I have a table Region. It contains 6 columns as CutomerName, Northregion, southregion, Westregion, eastregion and northeastregion.
Now i want to insert values to Region table. From one SP i aam calculating Volumes for each regions. EG. Exec SP_Getvolume 'Input'.
Input for SP is brand name. For each brand, and for each region it will return the volumes of each customers. Result of SP will be like this.
CustomerName NorthRegion SouthRegion Eastregion
C1 234.56 789.45 980.8
C2 43.7 578.98 3243.90
Now i want to insert this output to my Region table. Here for each brands no. of columns will be changing. So dynamically i want to insert all columns whatever SP is returning.
Please help me. |
|
How to insert columns dynamically
