I've table TransactionHistory table.
in Which it captures every transaction of invoices.
Strcutre of table -
ID Date(datetime), UserID, Amount, DocumentType(In my case SI), Document_no
I want to capture invoicer count per day, per week and per month.
I am stuck to get the latest user,
so for 1 document, there will be 6 or 7 entries. and i want to capture the last. and do the group by to get count.
Any suggestions please..
View Complete Post