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 |
|
mntfr
Starting Member
1 Post |
 Posted - 2015-04-14 : 15:16:29
|
| Hi i have a data base as followsProviders(provID PK, pvName)categories(ctID PK, ctName)articules(artID PK, artName, ctID FK, artPrice, pvID FK)Facturation(facID PK, factDate, factTotal)FactDetail(factID FK, artID FK, factPriceDetail, factQuantity Detail)and i need to create a query to know how much I gain from each categorie between given dates |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-04-14 : 16:29:42
|
| depends what you mean by "how much I gain"What have you worked up so far for a query? |
 |
|
|
Maithil
Starting Member
29 Posts |
Posted - 2015-04-15 : 01:19:44
|
| Make Practice to give Example to get exact solution.Give some Example Data in proper Manner and with Proper Table Definition. |
|
|
|
|
|
|
Sum and group by