David Emerson
newsgrps at dalyn.co.nz
Wed Sep 12 21:28:24 CDT 2007
I have created a temporary table called @ttmpBWSGoalCashFlow in a
stored procedure.
I would like to add columns to the table based on the data in another table.
Part of my stored procedure looks like this (Assume that cc has been
declared as a cursor which returns the names of the new columns):
DECLARE @col varchar(100)
DECLARE @strsql varchar(4000)
OPEN cc
FETCH NEXT FROM cc INTO @Col
WHILE @@fetch_status=0
BEGIN
SELECT @strsql = 'ALTER TABLE @ttmpBWSGoalCashFlow
add [' + @col + '] money'
EXEC (@strsql)
FETCH NEXT FROM cc INTO @Col
END
The error I get when I run this is "Incorrect syntax near
'@ttmpBWSGoalCashFlow'". My guess is that because the temporary
table is a variable, SQL can't recognise it as part of the
string. Can anyone help me with the correct syntax?