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 |
|
imranabdulaziz
Yak Posting Veteran
83 Posts |
 Posted - 2010-10-07 : 07:37:12
|
| Dear allI have three tables first is main hdr which contains single records of employee sales , second table contains differnent customer for that month and third is sales details that is it contains items sold to the customerLike MainHdrTableMainHdrID Employee zone month Year1 abc East 4 20102 efg West 4 20103 test East 4 2010CustHeaderTable CustHdrId MainHdrID Customer100 1 Esd101 1 Abc102 2 Esd103 3 Wer103 3 Ter Sales DetailsCustHdrID ItemCode Qty100 Item1 5101 Item1 10101 Item2 4102 Item1 5103 Item3 8100 Item3 10102 Item2 5103 Item1 5 Now I need to find out details in following fashionMonth April 2010item Zone east Zone west Zone north Zone southItem1 20 Item2 4 Item3 18 Please suggest |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-10-17 : 04:54:33
|
| can you explain how you got values only for eastzone in output? where did west value go?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
how to solve this query