Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select with Sales by Month
Message
From
16/10/2005 13:41:43
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Select with Sales by Month
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01059504
Message ID:
01059504
Views:
41
Hi all

I need to make a SQL statement to retrive the month sales for all customers filtered by start date and end date (Ex: Start: 2005-01-01 End 2005-12-31).
So i need customer 0001 sales January, february, etc...
                   0002 sales january, march, etc.
Any smart aproach to do that.

João Batista
Next
Reply
Map
View

Click here to load this message in the networking platform