Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
datamark
Starting Member
1 Post |
 Posted - 2002-07-30 : 14:43:26
|
| I am trying to find out how i could do this:I have two tables1. workorders2. workorder_itemsworkorders & workorder_items can be joined with ORDER_IDWorkorders table has the following fields:acct, sales_rep, order_type ( plus there are others )Workorder_items has the following fields:service_code, charge, disco_dateHere is what I am trying to doI want to be able to run a query that would give me all sales_rep numbers grouped by 10-19 then 20-29 then 30-39 etc & count their account_id for a certain disco_dateThat way I would see something like this:10-19 25420-29 31030-39 900and so onWhat would be the best way to write that query?Thank you |
|
|
ojn.
Starting Member
10 Posts |
|
|
|
|
|
Query question please