Database

DESCR                CYCLES                
---------------------------------------
Galloway A Ms         20 21  
Gama, E               20 21   
Giatsi M Ms           20 21   
Gibbon F Prof         20 21  
Gibson C Ms           20 21   
Gilfillin, P          20 21   
Galloway A Ms         21 20   
Gama, E               21 20  
Giatsi M Ms           21 20   
Gibbon F Prof         21 20   
Gibson C Ms           21 20   
Gilfillin, P          21 20 

ALTER PROC [dbo].[sp_Get_Staff_Cycles]
(
@ACTIVITY_ID INT
)
AS
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FINAL]'))
drop table [FINAL]

SELECT  S.DESCR,ISNULL(MTN.CYCLETEMPLATE,C.CYCLES) AS CYCLETEMPLATE
INTO FINAL FROM TBL_STAFF S
INNER JOIN MTM_ACTV_STAFF MTN ON
S.ID = MTN.STAFF
LEFT OUTER JOIN tbl_Cycles_Staff C
ON C.IDL = MTN.ID
WHERE MTN.ACTV = @ACTIVITY_ID

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

/*
This Sp is the one that Arrange the Cycles from the Grid, the way Paul requested it
if the Grid Has more than one description, append the cyle to another one and remove it
*/

ALTER  PROC [dbo].[sp_Get_Staff_Cycles_internal]

AS
--
 IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FINAL_NEW_FINAL]')) 
 DROP TABLE FINAL_NEW_FINAL
--ADD THIS TO A NEW TABLE NAMED 'FINAL_NEW_FINAL'
Select t1.DESCR,  STR(t1.CYCLETEMPLATE) + ''+ STR(t2.CYCLETEMPLATE) AS [CYCLES]
INTO FINAL_NEW_FINAL From FINAL t1, FINAL t2
Where t2.DESCR = t1.DESCR
And t2.CYCLETEMPLATE <> t1.CYCLETEMPLATE;

--Get the Missing Records
--INSERT THE ONE THAT WAS MISSING 
INSERT INTO FINAL_NEW_FINAL
SELECT DESCR ,CYCLETEMPLATE 
FROM FINAL 
WHERE DESCR NOT IN (SELECT DESCR FROM FINAL_NEW_FINAL)

-- Final Data for Rendering
SELECT DESCR,CYCLES FROM  FINAL_NEW_FINAL

<br />
DECLARE SomeCursor CURSOR FOR <br />
				SELECT ...<br />
				FROM PersonMap<br />
				WHERE  <br />
					Id = XXXX<br />