I'd like to pass to a StoredProc comma-separated string and insert the data into a temporary table for futher treatment. Exemple:
string will be like:
'abc123', 100, True, '001-123-01A', 99, 'abc456', 110, True, '001-888-02B', 90, 'abc789', etc...
temporary table will be:
create table #Details (
the 5 first entries will be inserted into the table, then the 5 following entries, and so on until the end of the string. how can I do that??
thanks for your time and help