I have a stored procedure in sql server 2012 which I pass in a comma separated value, loop it and update a table...all good.
but now I have 2 lists to handle now which they need to be paired in order, the lists contains....E.G
list 1 -SER123, SER456, SER789
list 2 - MOD123, MOD456, MOD789
The table for example will have 3 columns - Order, Serial, Module
the position of these 2 lists are paired (SER123- MOD123) so when I update the table they need to be in the same row.
See the attachment of how I do just now with one list.
Any help greatly appreciated.