Re: Statement Only Erros in Procedure

[Peter Brawley]

Quote

DECLARE cardsubtype nvarchar(128);

UPDATE t_Card c LEFT JOIN t_CardType ct ON c.CardTypeId = ct.CardTypeId SET c.CardType = ct.CardType;

# Add subtypes
DECLARE updateCur CURSOR FOR ...

There must be no code before a DECLARE in a block. If you must execute that Select statement there, star a new BEGIN...END block before declaring the cursor.

BTW, UPDATE...LEFT JOIN... is unsound unless there is a solid reason to set c.carttypeid to null when the Left Join condition fails.

Nor is it clear to me why you can't accomplish what this sproc tries to do with straight SQL statements.