SELECT o.companyname, a.status, a.startdate, a.enddate, a.internalRefNum, case when ( (a.startdate is not null and a.startdate > getdate()) or (a.enddate is not null and a.enddate < getdate())) then 'yes' else 'no' end as expired FROM tbl_PRD_Skus s with (nolock) INNER JOIN tbl_CRM_AffiliationProducts a with (nolock) ON (s.skuid = a.skuID) INNER JOIN tbl_OPR_ClientOperators o with (nolock) ON (o.operatorid = a.affiliationorgid) WHERE s.OwnerID = AND s.FSL_TableCode = AND s.skuID = AND ( a.startdate is null or a.startdate <= getdate() ) AND ( a.enddate is null or a.enddate >= getdate() ) ORDER BY o.companyname asc

  • #companyname#

    Approved Dual Specified Single Specified #htmleditformat(qryAfflStatus.status)#
    Code: #internalRefNum#
    #dateformat(qryAfflStatus.startdate,"mm/dd/yyyy")# - #dateformat(qryAfflStatus.enddate,"mm/dd/yyyy")#