Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-25 : 22:46:54
|
Arshad writes "Hi,
I have a products table and in my reports (Crystal) , products are arranged in column's so as to show a summary of sales by salesman. for this columnwise arrangement of products i create , in a stored procedure , a temp table with fix columns of the product and populate the sales in it. if a new product is added i will have to change the sp and add a column in storedprocedure .
I tried adding a column dynamically by first fetching all product items in a cursor and adding that no. as columns in the temp table , but ..
Question: Is it possible to add column's to temp tables dynamically ? If yes how?
i am Using SQL Server 7
Arshad" |
|
|
|
|
|
Adding columns dynamically to a temp table in sp