I am trying to make a hefty SP that could move data around within our system without having to make multiple calls.
The values would be passed into a Nvarchar(max) like this
1,2
3,4
5,6
Of course no carriage return. So 1,2,3,4,5,6
so I either need C# code in the SP to separate it or TSQL function. Kind of like list as table but with two columns. any ideas on how to make this fast and easy? I will be putting this into a var table to use for joins and updates of historical records.