declare @relation_code nvarchar(1024)
set @relation_code = '#10000#10002'
set @relation_code=substring(@relation_code,2,len(@relation_code))
select @relation_code
set @relation_code=@relation_code+'#'
declare @cID varchar(100)
declare @cEidx int
while charindex('#',@relation_code) > 0
begin
set @cEidx = charindex('#',@relation_code,1)
set @cID = substring(@relation_code,1,@cEidx-1)
set @relation_code=substring(@relation_code,@cEidx+1,len(@relation_code)-@cEidx)
print @cID
end