[thelist] MSSQL Stored Proc problem

rudy r937 at interlog.com
Fri Jan 3 15:25:01 CST 2003


> 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

have you tested the query in query analyzer or enterprise manager?


rudy




More information about the thelist mailing list