问具有不同日期条件的Server查询

EN

DECLARE @FirstDay DATETIME
SET @FirstDay = DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0)

DECLARE @LastDay DATETIME
SET @LastDay = DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0)) 

DECLARE @Yesterday DATETIME
SET @Yesterday = dateadd(day,datediff(day,1,GETDATE()),0)


DECLARE @DaysInMonth int
SET @DaysInMonth = DAY(EOMONTH(GETDATE()))

DECLARE @NoOFSundaysInMonth int
SET @NoOFSundaysInMonth = DATEDIFF(WK, DAteAdd(DD, -1,@FirstDay), DAteAdd(DD, 1, @LastDay)) 

DECLARE @NoOfDaysWithoutSunInMonth int
SET @NoOfDaysWithoutSunInMonth = @DaysInMonth - @NoOFSundaysInMonth


DECLARE @NoOFDaysTillYes int
SET @NoOFDaysTillYes = DATEDIFF(d, @FirstDay, GETDATE())

DECLARE @NoOFSunTillYes int
SET @NoOFSunTillYes = DATEDIFF(WK, DAteAdd(DD, -1,@FirstDay), DAteAdd(DD, 1, @Yesterday)) 

DECLARE @NoOfDaysWithoutSunTillYes int
SET @NoOfDaysWithoutSunTillYes = @NoOFDaysTillYes - @NoOFSunTillYes

SELECT
@FirstDay AS 'First_Day', 
@LastDay AS 'Last_Day', 
@Yesterday AS 'Yesterday',

@DaysInMonth AS 'Days_In_Month', 
@NoOFSundaysInMonth AS 'No_Of_Sundays', 
@NoOfDaysWithoutSunInMonth AS 'No_OF_Days_Without_Sun',

@NoOFDaysTillYes AS 'No_OF_Days_Till_Yesterday',
@NoOFSunTillYes AS 'No_OF_Sundays_Till_Yesterday',
@NoOfDaysWithoutSunTillYes AS 'No_OF_Days_Without_Sunday_Till_Yesterday'

final =Target_L * X/Y

final =Target_L * @NoOfDaysWithoutSunTillYes / @NoOfDaysWithoutSunInMonth