0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people seeking specific hardware recommendations

declare @CompanyCodes varchar(200)
set @CompanyCodes = '1,2,3,4,5,aa,bbb,cccc,ddddd,eeeeee'

while len(@CompanyCodes) > 0
begin
  
  print left(@CompanyCodes, charindex(',', @CompanyCodes+',')-1)
  set @CompanyCodes = stuff(@CompanyCodes, 1, charindex(',', @CompanyCodes+','), '')
end

fork query

edited jan 23 18 anonymous

created apr 5 12 Mikael Eriksson