job step error - 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

SQL Server Development (2000)

job step error

Author

Topic

csharpula
Starting Member

2 Posts

Posted - 2005-03-30 : 07:31:20

I get an error while I am trying to run this job step,what is wrong here?
It writes that something near SELECT wrong.

DECLARE
@counter int

SET @counter = SELECT value from parameters
SET @counter=@counter+1
exec sp_bup @counter
UPDATE parameters
SET value=@counter

10xs a lot!

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-03-30 : 07:40:45

Instead of SET @counter = SELECT value from parameters
Use
Select @counter = value from parameters

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources