Need to insert the dates between the start date and end date

[rubansigamani]

Start date: 03-04-2007
End date: 08-04-2007

I need the get the dates bound between the start date and the end date.
Also i need to insert those dates into a table in a single query.

Could you help me out soon......

[ck9663]

Start date: 03-04-2007
End date: 08-04-2007

I need the get the dates bound between the start date and the end date.
Also i need to insert those dates into a table in a single query.

Could you help me out soon......

Lots of ways. What's your tables structure? Do you need this in a stored proc or there's a front-end apps that handles the two dates?


-- CK

[sarinmonu]

Lots of ways. What's your tables structure? Do you need this in a stored proc or there's a front-end apps that handles the two dates?

-- CK

Hi can you please send me a script for this

my requirement is , i need to generate dates between two dates and store in a table, eaxmple i take the current date as end date and a date which is six month old, it needs to insert all dates inbetween it

my table is

CREATE TABLE emp_attendence (
attend_date datetime default '00-00-0000',
PRIMARY KEY (attend_date)
) TYPE=MyISAM;

can you mail me the script to mailsarin@yahoo .com

thanks in advance

[deepuv04]

Hi can you please send me a script for this

my requirement is , i need to generate dates between two dates and store in a table, eaxmple i take the current date as end date and a date which is six month old, it needs to insert all dates inbetween it

my table is

CREATE TABLE emp_attendence (
attend_date datetime default '00-00-0000',
PRIMARY KEY (attend_date)
) TYPE=MyISAM;

can you mail me the script to mailsarin@yahoo .com

thanks in advance

Hi,

here is the query to get dates between startdate and enddate

[code=sql]
Select dateadd(day,num ber,'2008-06-15')
from master.dbo.spt_ values
where master.dbo.spt_ values.type='p'
AND dateadd(day,num ber,'2008-06-15')<=('2008-06-25')
[/code]

thanks