[dba-SQLServer] Reports

Always happy to help, Francisco, especially given the number of times 
you have helped me. But on this one I think I need a little more 
explanation. Are you wanting an empty row to appear for the months that 
are missing, or what?

Arthur

Francisco Tapia wrote:

>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
>
>
>
>  
>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.5.1 - Release Date: 12/13/2004