[thelist] MSSQL Stored Proc problem

[rudy]

> > i guess what i was asking was, did you test the query itself, as a

> yes.
> ie SET @BUILDINGLIST = 1,4,5,7,9
> causes problems when presented this way. when I wrap the right-hand side
> in single quotes it complains about implicit conversions.

um, no

SET is transact-sql

i meant just the query itself, the SELECT sql, no transact-sql SET commands,
variable substitution, or other stored proc-isms, just the SELECT with
hardcoded numerics

  SELECT ... WHERE QuestionNumber IN ( 1, 4, 5, 7.3 )

has that ever run successfully?


rudy