I would like to optimise this request

userDev 2016-10-14 10:05:08

Aaron Bertrand 2016-10-14 12:43:57
Have you thought of using table-valued parameters to pass or store those values 1-10, instead of using whatever looping mechanism is splitting apart a comma-separated string?