Please see question #: https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_22774332.html
I have a Stored Procedure that is using an IN clause, but it's having a problem converting data types. One solution was given using EXEC(), and while it works, I cannot use that solution because it requires relaxing my security settings. Another solution was given - parsing a string variable, putting the parsed variables into a virtual table, and then using that virtual table to complete the stored procedure. This question is devoted to the second solution (or an alternate that does not require relaxing my security settings).
So, can someone please create some code that would demonstrate how to use the virtual table? Thanks.