I have a sales table that has data from 2005 to current date.
I need to create a summary table that would pull the last date of each day starting from 2005 to current date.
the summary table would have
Date, sku, cost amount
select distinct year(invoicedate),month(invoicedate),itemid,costamount from salesasb
order by year(invoicedate),month(invoicedate)
How do I run this ????