Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
select INVOICEDATE, ACCOUNT, FEE , case when INVOICDATE in [QtrEndDate] then ‘Mgmt Fee’ else ‘Final Fee’ end as TYPE from INV_INVOICESUMMARY where INVOICEDATE >= @FromDate and INVOICDATE DATE <= @ToDate
|qry in a qry worked by week ending date! how do I get it to work by weeks (y-t-d) instead of one week at a time?||25||86|
|What can the "OPTION" in the GROUP help me in my query?||4||35|
|compare date to getdate()||8||15|