SQL Server: Handle Delimited String passed as Parameter to Stored Proc

In your application, you may need to pass multiple values as a parameter to a stored procedure. This article shows how to pass delimited values to the procedure and get data