Monthly Archives: February 2006

Because of how SQL Server compiles stored procedures, it cannot handle a parameter being used in the IN clause that contains a parameter list. There are a few ways to handle this, one very common seems to be to generate a dynamic SQL statement and concatenate the contents of the parameter to the SQL statement … Continue reading »