[thelist] MSSQL Stored Proc problem

Steve Lewis slewis at macrovista.net
Fri Jan 3 15:53:01 CST 2003

rudy wrote:
>>How can I pass the variable-length list of question_numbers to the
>>stored proc?

> as a single varchar parameter, containing a comma-delimited list
> since they are float, i.e. numbers (okay, i won't ask), you don't even have
> to wrap single quotes around each list item

It barfed on that.

> have you tested the query in query analyzer or enterprise manager?
Yes, with quotes it complains about the implicit conversion from varchar
to float.  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.


More information about the thelist mailing list