Thanks to every one who is supporting here.
I have a query:
Table A: supplierid, suppliername
TableB: ordernum, supplierid, category, orderqty, orderdate
- grouping is done by month
- total quantity is irrespective of category qty
- Category would be passed by parameter in storedproc
- Whole idea is that user wishes to see the how many units of a category has been ordered againt the total quantity of a month
I want results something like :
ordrnum suppliername categoryqty totalqty
Jan 123 abc 100 1000
Feb 456 qwe 200 3000
Mar 789 str 150 1500
what query should be passed to achieve this.
Many thanks in advance.