if you are using query analyser to insert your SP, click the tick button first (before trying to run it) and it might help you. ----- Original Message ----- From: "Paul Johnston" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 15, 2003 12:46 PM Subject: RE: [ cf-dev ] SQL question
> 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] __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- ** 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]
