Pass Comma Delimited String as Parameter to Stored Proc
I thought this was resolved. The stored procedure compiled but did not run.
-- INSERT INTO StockDataWork
-- (SymbolName, OpenPrice)
--SELECT f1.value, f2.value
-- FROM dbo.ParmsTolist(@ListSymbolName , ',') f1
-- JOIN dbo.ParmsTolist(@ListOpenPrice , ',') f2
-- on f1.row_num = f2.row_num
-- WHERE f1.value is not null
-- and rtrim(f1.value) <> ''