Sql Server Cursor error (incorrect syntax near the "a" sign)

Question

The following query results in an error with the following message:

Incorrect syntax near the keyword 'for'. How should I get around this error...

I think in the query below SQL Server does not like the "@" sign.....

Any thoughts? Thanks!!!

Declare ObsSet_Cursor for 
 Select o.EventSetName,
        o.EventSetDisplay, 
        o.EventSetDescription, 
        o.ChildSetName
  From   ##Final f, 
         ##ObsSetLevel o
  Where  f.ChildSetName = o.EventSetName and 
         f.ChildSetName = @str

OK, this code has so many sql antipatterns. First, do not use cursors if a set-based alternative exists which they do over 90% of teh time. Next, implicit joins are very bad and there is noexcuse for writing them inteh 21st century. Finally global temp tables can create problems as they are visible to other seessions (and not just the ones you intended). Do not use them unless you have no other choice. — HLGEM
– HLGEM, Commented Aug 13, 2013 at 20:18

i-one · Accepted Answer · 2013-08-13 19:44:03Z

1

You missed cursor keyword:

Declare ObsSet_Cursor cursor for ...

answered Aug 13, 2013 at 19:44

i-one

5,1201 gold badge33 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sql Server Cursor error (incorrect syntax near the "a" sign)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related