Store procedure - 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)

Store procedure

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-05-20 : 08:32:25

fred writes "When I run this code with the SQL Query Analyser, it provides results. But when I try to past it in a store procedure, it retruns the error :"Error 207 - invalid column name 'CATEG_VEHICULE'. What is wrong ?

ALTER TABLE INSPECSTEP10
ADD CATEG_VEHICULE CHAR(2)
GO
UPDATE INSPECSTEP10
SET INSPECSTEP10.CATEG_VEHICULE =
CASE
WHEN GENRE.CODE IN ('VP','AA','AB','AC','AD','AE','AF','SB','SW') AND USAGE.CODE <> '11' THEN '01'
WHEN USAGE.CODE = '11' THEN '02'
WHEN GENRE.CODE IN ('BC','TB') THEN '03'
WHEN GENRE.CODE IN ('CT','FA') THEN '04'
WHEN GENRE.CODE IN ('TR','CV','SF') THEN '05'
WHEN GENRE.CODE = 'AR' AND INSPECSTEP10.WEIGHT35 = '0' THEN '06'
WHEN GENRE.CODE = 'AR' AND INSPECSTEP10.WEIGHT35 = '1' THEN '07'
WHEN GENRE.CODE = 'OS' THEN '08'
WHEN GENRE.CODE NOT IN ('VP','AA','AB','AC','AD','AE','AF','SB','SW','OS','AR','TR','CV','SF','CT','FA','BC','TB') THEN '09'
END
FROM INSPECSTEP10, GENRE, USAGE
WHERE (GENRE.CODE = INSPECSTEP10.GENRE)
AND (INSPECSTEP10.AFFECTATION = USAGE.CODE)
GO"

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-05-20 : 08:32:25

You can't use GO inside a stored procedure.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources