DECLARE @StatusCodeX char(11)
	DECLARE @StatusCodeY char(11)

    DECLARE c1 CURSOR FOR
    SELECT CodeValue FROM tb_Decode WHERE DecodeNumber = 2 ORDER BY RecordNumber 

    OPEN c1

    FETCH NEXT FROM c1
    INTO @StatusCodeX

		DECLARE c2 CURSOR FOR	
		SELECT CodeValue FROM tb_Decode WHERE DecodeNumber = 2 ORDER BY RecordNumber

	
    WHILE @@FETCH_STATUS = 0
    BEGIN
	
		OPEN c2

		FETCH NEXT FROM c2
		INTO @StatusCodeY

		WHILE @@FETCH_STATUS = 0
		BEGIN

			FETCH NEXT FROM c2
			INTO @StatusCodeY
			
			SELECT getStatusCountOnDate('1/1/2000', @StatusCodeX, '1/1/2000', @StatusCodeY)
					
		END

		CLOSE c2
		
        FETCH NEXT FROM c1
        INTO @StatusCodeX
		
    END

		DEALLOCATE c2
	
    CLOSE c1
    DEALLOCATE c1