-- Declarations
DECLARE @tblResult TABLE (asset_id char(9), sum_amt decimal(19,3), count_amt int)
DECLARE @asset_id char(9), @sum_amt decimal(19,3), @count_amt int

	SELECT @asset_id = ''	-- This is our iteration key
	SET @sum_amt = 0	-- Will be incremented for each record
	SET @count_amt = 0	-- Will be incremented for each record
	WHILE 1=1 BEGIN		-- Loop over all asset_ids
		-- Load the next asset_id and add amount to running total var and increase count for the new record.
		SELECT TOP 1 @asset_id = asset_id, @sum_amt = @sum_amt + cap_issue_amt, @count_amt = @count_amt + 1 
		FROM dbo.RRefasset WHERE asset_id > @asset_id ORDER BY asset_id ASC
		IF @@ROWCOUNT = 0 BREAK
		-- Insert new row into temporary results table
		INSERT @tblResult SELECT @asset_id, @sum_amt , @count_amt 
	END
	SELECT asset_id, sum_amt, count_amt FROM @tblResult

select
    a.invoice_id,
    a.status as 'stA',
    a.stdate as 'dtA',
    b.status as 'stB',
    min(b.stdate) as 'dtB'
from
     workflow a
join workflow b
  on  a.invoice_id = b.invoice_id
  and a.stdate < b.stdate
  and a.status <> b.status
group by
    a.invoice_id,
    a.status as 'statusA',
    a.stdate as 'stdateA',
    b.status as statusB