declare @ids varchar(40) set @ids='''011'',''012'',''013''' declare @len int set @len=len(@ids)-len(replace(@ids,',',''))+1 while(@len>1) begin select substring(@ids,2,patindex('%,%',@ids)-3) ID,* from A select @ids=right(@ids,len(@ids)-patindex('%,%',@ids)),@len=@len-1 end select substring(@ids,2,len(@ids)-2) ID,* from A
set @ids='''011'',''012'',''013'''
declare @len int
set @len=len(@ids)-len(replace(@ids,',',''))+1
while(@len>1)
begin
select substring(@ids,2,patindex('%,%',@ids)-3) ID,* from A
select @ids=right(@ids,len(@ids)-patindex('%,%',@ids)),@len=@len-1
end
select substring(@ids,2,len(@ids)-2) ID,* from A