[dba-SQLServer] Reports

perhaps someone here can help me out so this reporting goes a lot smoother :)

Here is a sample snapshot of my data

8/1/2003, 1, SampleText, Qty1
10/1/2003, 1, SampleText, Qty1
11/1/2003, 1, SampleText, Qty1
1/1/2004, 1, SampleText, Qty1
8/1/2004, 1, SampleText, Qty1

There is only data for these months... would you create a temp table
to fill in the rest of the months within the criteria?

ex: 8/1/2003 - 8/31/2004



-- 
-Francisco
http://pcthis.blogspot.com | PC news with out the jargon!