SQL:明年的过滤条件 [英] SQL: Filter condition for Next year
问题描述
Hello Everyone - 我在下面的查询中得到了不应该选择IgnoreAssistanceInactivityAutoClose = 1和 ResetDateForIgnoreAssistanceInactivityAC ='Nextyear-04-30 00:00:00.000'的应用程序。
在这种情况下,突出显示的应用程序已经"2020-04-30 00:00:00.000",明年它将是"2021-04-30 00:00:00.000" 。
因此,我不想硬编码,它应该通过变量或参数自动进行。
$
我认为它应该是条件的一部分。
Hello Everyone - I got this below query where I shouldn't pick Application whose IgnoreAssistanceInactivityAutoClose =1 and ResetDateForIgnoreAssistanceInactivityAC = 'Nextyear-04-30 00:00:00.000'.
In this case the highlighted Application has got '2020-04-30 00:00:00.000', Next year it will be '2021-04-30 00:00:00.000'.
So, I don't want to hard code it, it should be automatically through variable or parameters.
I think it should be some where condition.
Select distinct vwpa.PatientId, vwpa.ProgramId, Vwpa.ApplicationId, AssistanceTypeId, vwpa.StatusDate, isnull(pd.InvoiceDate,0),
DATEDIFF(day, isnull(pd.InvoiceDate, 0), Getdate()) Inactivedays,
DATEDIFF(day, isnull(vwpa.StatusDate,0),Getdate()) Inactivedays_Status,
ApplicationStatusreasonId, app.IgnoreAssistanceInactivityAutoClose, app.ResetDateForIgnoreAssistanceInactivityAC
From dbo.vwPatientApplicationStatusCurrent vwpa
Inner Join program prg On vwpa.ProgramId = prg.ProgramId
Left Join [Application] app On vwpa.ApplicationId = app.ApplicationId
Left Join PatientDistribution pd On vwpa.ApplicationId = pd.ApplicationId
and vwpa.PatientId = pd.PatientId
and pd.InvoiceDate = (
Select max(InvoiceDate)
From PatientDistribution pd1
Where vwpa.ApplicationId = pd1.ApplicationId
and vwpa.PatientId = pd1.PatientId
)
Where ApplicationStatusId = 1
and AssistanceTypeId not in (2) --copay
and prg.AssistanceInactivityAutoCloseIndicator = 1 --Program level Indicator
and app.InactiveDateTime is null
and app.SoftDeleteDateTime is null
and vwpa.patientid = 118626
推荐答案
convert(char(4),year(sysdatetime())+ 1)+'0430'
convert(char(4), year(sysdatetime()) + 1) + '0430'
这篇关于SQL:明年的过滤条件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!