[thelist] MSSQL Stored Proc problem

rudy r937 at interlog.com
Fri Jan 3 17:28:01 CST 2003

>> has that ever run successfully?
> yes.

ah, thanks

well, i imagine my next guess would be what dex suggested, rather than an
inline SELECT in the stored proc with a variable in it, try constructing the
SELECT as a string first

  SET @BUILDINGLIST =  '  2, 4, 6, 8.01 '
  exec(  'SELECT ... WHERE QuestionNumber IN (' + @BUILDINGLIST + ')'  )

beyond that, i'm out of ideas...


More information about the thelist mailing list