0

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

mohamed faisal
  • 406
  • 1
  • 6
  • 21

0 Answers0