Home > IT Answers > Development > SQL Server query
Piq992
0 pts.
 SQL Server query
SQL
Hi ppl, I want to create a query that tracks a customer's order patterns on a monthly basis over the last 12 months. I have completed the query, however there are a couple of months (eg Nov-03) were no orders have been placed by any customer. I want to know how to display the month with 0 sales rather than it not appearing at all. Thanks in advance

Software/Hardware used:
ASKED: August 25, 2004  12:40 AM
UPDATED: August 25, 2004  12:52 AM
RELATED QUESTIONS
Answer Wiki:
http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid526288_tax285649,00.html
Last Wiki Answer Submitted:  August 25, 2004  12:52 am  by    0 pts.
All Answer Wiki Contributors:    0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _