[thelist] MSSQL Stored Proc problem

[rudy]

>> 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...

rudy