Last day of Month

Last Post 25 Jan 2010 08:00 AM by JASBRYDEN. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
JASBRYDEN
New Member
New Member

--
25 Jan 2010 06:24 AM
Hi

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 ????
JASBRYDEN
New Member
New Member

--
25 Jan 2010 08:00 AM
wow !!!

excellent man.

Thanks Alot !!!!!!!
You are not authorized to post a reply.

Acceptable Use Policy