Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement