[dba-SQLServer] Values for date ranges

David,

Yeah, that would get too big for it to be practical to load it into a
new table with the necessary identity each time. I would not suggest
adding the identity to your table as you might delete rows leading to
gaps in the row numbers.

I would be interested in a comparison of your cursor and Stuart's
method if you try both. I am not absolutely convinced that a cursor
approach would lose out here.

Francis R Harvey III
WB 303, (301)294-3952
harveyf1 at westat.com


> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com 
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf 
> Of David Emerson
> Sent: Tuesday, July 20, 2004 2:16 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: RE: [dba-SQLServer] Values for date ranges
> 
> 
> Francis,
> 
> The table is not large at this stage (only 700 records with 
> about 60 added 
> each month).
> 
> I think that what you are suggesting is what I envisaged I 
> need to do - 
> just looking to see if there were any easy tricks.
> 
> David
<snip>