SELECT DISTINCT  
			  sttrgprf.register_id
			, sttrgprf.register_group
			, SUM((CAST(DATEDIFF(MI 
					, ISNULL(sttrgprf.start_time, 0.00)
					, ISNULL(sttrgprf.end_time, 0.00)) AS decimal) 
					/ 60)
					* (CAST(ISNULL(sttrgprf.end_week,0.00) AS DECIMAL) 
					- CAST(ISNULL(sttrgprf.start_week,0.00) AS DECIMAL) + 1))
					AS Hrs
			, sttrgprf.start_week
			, sttrgprf.end_week
		FROM sttrgaos
  INNER JOIN sttrgprf 
		  ON sttrgaos.acad_period = sttrgprf.acad_period 
		 AND sttrgaos.register_id = sttrgprf.register_id 
		 AND sttrgaos.register_group = sttrgprf.register_group
       WHERE (sttrgaos.acad_period = @p_acad_period) 
		 and (sttrgaos.raoscd_link = @aos_code) 
		 and (sttrgaos.rprocd_link = @aos_period)
    GROUP BY  dbo.sttrgaos.acad_period
			, sttrgprf.register_id
			, sttrgprf.register_group
			, sttrgaos.raoscd_link
			, sttrgaos.rprocd_link
			, sttrgaos.aos_code
			, sttrgaos.aos_period
			, sttrgprf.start_week
			, sttrgprf.end_week

ALTER PROCEDURE [dbo].[del_hrs_actual_0506] 
	  @p_acad_period nvarchar (5)
	, @aos_code nvarchar (11)
	, @aos_period nvarchar (5)
	, @TableName nvarchar(10)
	, @claim_period tinyint
	, @hrs_actual decimal(18,2) OUTPUT
AS

BEGIN
DECLARE @Hours decimal(18,2), @TempHours decimal(18,2), @RegisterId varchar(7)
, @RegisterGroup varchar(5), @root_hrs DECIMAL(18,2), @lnk_acad_period char(5)
, @lnk_aos_code char(11), @lnk_aos_period char(5)

--X002548
--Lets check the return of the sproc exec
DECLARE @rc int, @n = 0
--this is not used
--DECLARE @TempTable TABLE(register_id char(7),register_group char(5),hrs decimal(18,2))

INSERT INTO TempTable -- (Should always supply a column list)
     SELECT DISTINCT  
			  sttrgprf.register_id
			, sttrgprf.register_group
			, SUM((CAST(DATEDIFF(MI 
					, ISNULL(sttrgprf.start_time, 0.00)
					, ISNULL(sttrgprf.end_time, 0.00)) AS decimal) 
					/ 60)
					* (CAST(ISNULL(sttrgprf.end_week,0.00) AS DECIMAL) 
					- CAST(ISNULL(sttrgprf.start_week,0.00) AS DECIMAL) + 1))
					AS Hrs
			, sttrgprf.start_week
			, sttrgprf.end_week
		FROM sttrgaos
  INNER JOIN sttrgprf 
		  ON sttrgaos.acad_period = sttrgprf.acad_period 
		 AND sttrgaos.register_id = sttrgprf.register_id 
		 AND sttrgaos.register_group = sttrgprf.register_group
       WHERE (sttrgaos.acad_period = @p_acad_period) 
		 and (sttrgaos.raoscd_link = @aos_code) 
		 and (sttrgaos.rprocd_link = @aos_period)
    GROUP BY  dbo.sttrgaos.acad_period
			, sttrgprf.register_id
			, sttrgprf.register_group
			, sttrgaos.raoscd_link
			, sttrgaos.rprocd_link
			, sttrgaos.aos_code
			, sttrgaos.aos_period
			, sttrgprf.start_week
			, sttrgprf.end_week

DECLARE RetrieveAOS CURSOR STATIC LOCAL FOR

	SELECT  stclvlnk.aoscd_link
		  , stclvlnk.lnk_period
	   	  , stclvlnk.lnk_aos_period
      FROM  stclvlnk
 LEFT JOIN  stcfesdt 
	    ON stclvlnk.aoscd_link = stcfesdt.aos_code 
	   AND stclvlnk.lnk_period = stcfesdt.acad_period 
	   AND stclvlnk.lnk_aos_period = stcfesdt.aos_period
     WHERE (stcfesdt.qual_aim IS NULL or stcfesdt.qual_aim = '') 
	   AND (stclvlnk.acad_period = @p_acad_period) 
	   AND (stclvlnk.aos_code = @aos_code) 
	   AND (stclvlnk.aos_period = @aos_period)

SELECT @rc = 0, @n = 1

OPEN RetrieveAOS
FETCH NEXT FROM RetrieveAOS
INTO @lnk_aos_code, @lnk_acad_period, @lnk_aos_period

WHILE (@@FETCH_STATUS = 0)
  BEGIN

	exec @rc = dbo.del_hrs_actual_0506 @lnk_acad_period,@lnk_aos_code,@lnk_aos_period, @TableName, @claim_period, @hrs_actual OUTPUT
	
	SELECT 'Loop: '+CONVERT(varchar(5),@n)
		  +' Return Code: ' +CONVERT(varchar(5),@rc)
		  +' @hrs_actual: ' +CONVERT(varchar(5),@hrs_actual)

	SET @n = @n + 1

	FETCH NEXT FROM RetrieveAOS
	INTO @lnk_aos_code, @lnk_acad_period, @lnk_aos_period
  END

CLOSE RetrieveAOS
DEALLOCATE RetrieveAOS

Set @hrs_actual = (select coalesce(sum(hrs),0) 
					 from (select distinct register_id, register_group, hrs, start_week, end_week 
							 from temptable) as hours) --TJ 22.08 HF2


If Upper(@TableName) = 'DELESFUND'
	update delesfund 
	   set hours_actual = @hrs_actual
	 where claim_acad_period = @p_acad_period 
	   and claim_period = @claim_period 
	   and aos_code = @aos_code 
	   and aos_period = @aos_period
END