I want to split the string and print it through loop.
For example
Declare @storeID nvarchar(MAX)
SET @storeID = '1400,2001,2400,1201,1001,1302'
Declare @i int
SET @i=0
while(i<6) //6 is length
Begin
print @value
END
OUTPUT
------
1400
2001
2400
1201
1001
1302
split the string and print one by one through loop via variable @value