As per the previous email (although SQL server won't let me install this SP at all!)
It's not the exec that's the problem, it's the compilation of the SQL into SQL Server. Paul ------------------------------------------- Paul Johnston PJ Net Solutions Ltd http://www.pjnetsolutions.com [EMAIL PROTECTED] +44 (0)7866 573013 > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED]] > Sent: 15 January 2003 12:39 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] SQL question > > > how are you exec this? > > -----Original Message----- > From: Paul Johnston [mailto:[EMAIL PROTECTED]] > Sent: 15 January 2003 12:38 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] SQL question > > > Okay... > > I am getting an error which says I haven't declared two > variables. Whereas, the variables are declared directly above this. > > Here is the code: > > CREATE PROCEDURE spblah > > @lstblah varchar(1000) > > AS > > DECLARE @list varchar(1000) > DECLARE @patternNum INTEGER > > SELECT @list = @lstblah > SELECT @patternNum = CHARINDEX(',', @list) > > CREATE TABLE #mid ( > mid int NOT NULL > ) ON [PRIMARY] > GO > > WHILE (@patternNum > 0) > BEGIN > INSERT INTO #mid (mid) VALUES ( CAST(SUBSTRING(@list, 0, > @patternNum) as int) ) > SELECT @list = SUBSTRING(@list, @patternNum + 1, Len(@list) - > @patternNum) > SELECT @patternNum = CHARINDEX(',', @list) > END > > -- rest of Stored Procedure... > GO > > Now it's telling me I haven't declared the variable @list and > @patternNum, but not at the top, it's in the WHILE statement. > > Anyone? > > Paul > > ------------------------------------------- > Paul Johnston > PJ Net Solutions Ltd > http://www.pjnetsolutions.com > [EMAIL PROTECTED] > +44 (0)7866 573013 > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
