Split function in store procedure

Question

hi,

 

i have store procedure once i execute i will 1000+ row within 35 second

now i  passing variable and split it by using stringsplit function it getting to much time 

 

before use split function 35 sec

after 9+ mint

 

 

please assist me 

Answer 1

See it this article works for you.

http://www.c-sharpcorner.com/uploadfile/b4f4a4/birthday-reminder-in-C-Sharp/