[thelist] MSSQL Stored Proc problem

Steve Lewis slewis at macrovista.net
Fri Jan 3 16:30:01 CST 2003

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


More information about the thelist mailing list