Need help with script - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Need help with script

Author

Topic

tocroi72
Yak Posting Veteran

89 Posts

Posted - 2004-09-20 : 10:23:24

Hi all

I have this script:

Declare @Var int, @sql nvarchar(2000),@column nvarchar(100)
Set @var = 1
While @Var <= 32
begin
set @column = 'day' + convert(varchar,@var)

SET @sql = 'INSERT INTO Master SELECT YandMColumn,' + convert(varchar,@var) + ',' + @Column + ' From High'
Execute @sql
set @var = @var + 1
--print @sql
End

WHen i run the script, it returns me this erro message below
Could not find stored procedure 'INSERT INTO Master SELECT YearColumn,1,day1 From High'.

I have a table of data for a year like this
YandMColumn|Day1|day2|day3.....Day31|
1996/01 12 32 43
1996/02 14 31 56

and I want to create a table look like this

YandMColumn|Day|Amount
1996/01 1 12
1996/01 2 32
1996/01 3 43
1996/02 1 14
1996/02 2 31
1996/02 3 56

Thanks

raymondpeacock
Constraint Violating Yak Guru

367 Posts

Posted - 2004-09-20 : 10:30:26

Put brackets around the variable used in your exec.
EXEC (@sql)

Raymond

tocroi72
Yak Posting Veteran

89 Posts

Posted - 2004-09-20 : 10:46:18

Thanks! i totally forgot that.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources