I occasionally get one-off requests to modify some data, and the request comes with some values in CSV. Is there a way I can treat arbitrary CSV as a table or row source quickly and easily, even as inline data?
EG, can I do something like:
SELECT * FROM SomeSpecialCommand(' 147074,13 153987,16 147075,3 176405,16 176437,25 176436,14 176406,14 176439,13 176407,13 ') as MyInlineCSV
What prompted this was a request to modify inventory levels for ~100 items, and I was given a CSV with a SKU number and quantity (like above).