declare @strIDs varchar(8000)='-10,5,4,3,1'
   declare @guess decimal(30,10)=0
   DECLARE @t_IDs table(id int identity(0,1), value decimal(30,10))
   DECLARE @strID varchar(12), @sepPos int, @NPV decimal(30,10)
   set @strIDs = coalesce(@strIDs + ',', '')
   set @sepPos = charindex(',', @strIDs)
   WHILE @sepPos > 0  BEGIN
      SET @strID = LEFT(@strIDs, @sepPos - 1)
      INSERT INTO @t_IDs(value) SELECT (CAST(@strID AS decimal(20,10))) where isnumeric(@strID)=1
      SET @strIDs = RIGHT(@strIDs, DATALENGTH(@strIDs) - @sepPos)
      set @sepPos = charindex(',', @strIDs)
   END
   set @guess = case when isnull(@guess, 0) <= 0 then 0.00001 else @guess end
   select @NPV = SUM(value/power(1+@guess, id)) from @t_IDs
   WHILE @NPV > 0
   BEGIN
     set @guess = @guess + 0.00001
     select @NPV = SUM(value/power(1+@guess, id)) from @t_IDs
   END
   select @guess