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