Hi All,
I have a database that only updates on working days - for instance tonight it will roll forward and upload data from todays transactions then nothing for Saturday nothing for Sunday.
I have been asked to create a query (for averages) that will show all days in the month regardless if this is a business day or not.
SELECT AVERAGE(CURRENTACCOUNT), SUM(CURRENTACCOUNT), EXTRACTDATE
FROM SOMETABLE
WHERE EXTRACTDATE >= '01-APR-2016'
Any ideas on how to do this.
Many thanks
I have a database that only updates on working days - for instance tonight it will roll forward and upload data from todays transactions then nothing for Saturday nothing for Sunday.
I have been asked to create a query (for averages) that will show all days in the month regardless if this is a business day or not.
SELECT AVERAGE(CURRENTACCOUNT), SUM(CURRENTACCOUNT), EXTRACTDATE
FROM SOMETABLE
WHERE EXTRACTDATE >= '01-APR-2016'
Any ideas on how to do this.
Many thanks