I have a stored procedure that has logic to decide if I should add a an item to a kit. To do this I use a command like:
EXEC uspAddSKUToEPID @SKU='ABC_123', @EPID='123456789'
It works, but now I would like to add a list of SKUs to a list. For that I figured that I should wrap that stored procedure within another. IE
EXEC uspAddMultiSKUToEPID @MultiSKU='ABC_123,DEF_456,GHI_789', @current_EPID='123456789'
The problem is that now I need to interpret a list of parameters and loop through them to insert into the first stored procedure. Is this possible in TSQL only or do I need a procedural language to assist?