GetRecordMishnaCalendar

USE [JewishBooks2]
GO
/****** Object:  StoredProcedure [dbo].[GetRecordMishnaCalendar]    Script Date: 05/29/2015 19:22:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


-- =============================================
-- Author:      <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[GetRecordMishnaCalendar](@DATA DATE)

AS
BEGIN

    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.

  SELECT ms1.SubcategoryID AS FirstSubcategoryID, ms1.SubcategoryName AS FirstSubcategoryName,
        FirstID, FirstFilepath, FirstTier0Value, FirstTier1Value, FirstTier2Number, FirstTier2Value, FirstTier3Number, FirstTier3Value,
        ms2.SubcategoryID AS SecondSubcategoryID, ms2.SubcategoryName AS SecondSubcategoryName,
        SecondId, SecondFilepath, SecondTier0Value, SecondTier1Value, SecondTier2Number, SecondTier2Value, SecondTier3Number, SecondTier3Value

        FROM MishnahYomitCalendar5775 mc
        LEFT JOIN Subcategories ms1
        ON mc.FirstFilepath=ms1.Filepath

        LEFT JOIN Subcategories ms2
        ON mc.SecondFilepath=ms2.Filepath

        WHERE FirstID=(SELECT
                        ( FirstID +
                         (SELECT DATEDIFF(DAY,'2010-07-04', @DATA)*2)
                         )%(SELECT COUNT(*)*2
                        FROM MishnahYomitCalendar5775)
   FROM MishnahYomitCalendar5775
    WHERE FirstFilepath LIKE '\Books\020_msnh\20_zruim\01_MZ_BRAHOT_L1.obk' AND
          FirstTier2Number=1 AND
          FirstTier3Number=1
     );
    -- Insert statements for procedure here
RETURN
END