[thelist] MSSQL Stored Proc problem

[Steve Lewis]

rudy wrote:

>>Without quotes it complains about the SET (when building and
>>testing SPs I work in Query Analyser and just use DECLAREs and SETs to
>>build the environment) where we define the parameter.

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

--Steve