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) <> ''
Would you offer further assistance?
We don't any idea of what your data is, nor what the code of your SP is, nor what the code of your function ParmsTolist is, nor what testing/validating you have done.