SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 100 shops and whole month + 24 hour sale
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

usafelix
Yak Posting Veteran

Hong Kong
97 Posts

Posted - 08/26/2014 :  03:44:04  Show Profile  Reply with Quote
Anyone can help give a idea in writing query in this requirement. Basic on one sales table and using last month to review all shops with each hour the sales qty and amt and top 5 by amount ?

output like this.
Shop1 shop2 >>> shop 100
July 1
Time 08:00-09:00 qty 20 30 40
amt $300 $500 1000

Time 13:00-14:00 qty 14 10 24
amt $212 $333 $100

Time 23:00-15:00 qty 22 24 38

July 2 Time - ditto above
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000