[dba-SQLServer] Reports

If you have a date dimension table such as might be used in a
datawarehouse, you can simply join the two tables and pull the missing
dates out of the date dimension table.

Charlotte Foust


-----Original Message-----
From: Francisco Tapia [mailto:fhtapia at gmail.com] 
Sent: Monday, December 13, 2004 10:01 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [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!
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com