Home Forums SQL Server 2008 SQL Server 2008 - General Dynamic SQL and IN Operator RE: Dynamic SQL and IN Operator
bubs
SSCommitted
Points: 1620
More actions
April 14, 2011 at 8:47 pm
#1311920
Sorry, I made a mistake in my post. The string passed into the stored proc doesn't contain the single quotes. It is passed like this "10,11,12"
That is what the split function is for, it adds in the single quotes so I can use it with th IN operator.