--**************************************
--     
-- Name: Date Ranges
-- Description:To enter records with seq
--     uential dates in a table.
I extract the amount OF days WITH the DateDiff function Which includes month jumps. My code TO ADD sequential dates to a TABLE also calculates month jumps.
-- By: Rudolf Mouthaan
--
-- Inputs:If implemented as a Stored Pro
--     cedure it requires 3 parameters: 
@daysout int: the amount ofd days booked out
@EQ_ID char: equipment ID TO be booked
@BeginDate datetime: first day booked out
--
-- Returns:It will add a number of recor
--     ds to a table equal to the amount specif
--     ied in the parameter(daysout).
I created it FOR our Web based Equipment booking system(ASP).
--
-- Assumes:create this table:
CREATE TABLE [dbo].[equip_out] (
	[ID] [int] NOT NULL ,
	[Equipment_ID] [varchar] (4) NULL ,
	[From_date] [datetime] NULL 
) ON [PRIMARY]
GO
--
--This code is copyrighted and has-- limited warranties.Please see http://
--     www.Planet-Source-Code.com/vb/scripts/Sh
--     owCode.asp?txtCodeId=516&lngWId;=5--for details.--**************************************
--     

CREATE PROCEDURE DATERANGE @daysout int, @EQ_ID char, @BeginDate datetime AS
DECLARE @Reccount int
DECLARE @loopCount int
DECLARE @ID_Max AS int
DECLARE @BeginDate datetime
DECLARE @dayCount int
DECLARE @monthCount int
DECLARE @yearCount int
SELECT @ID_Max = (select max(ID) FROM equip_out)
SELECT @loopCount = 0
SELECT @dayCount = (select max(datepart(dd, from_date)) + 1 from equip_out)
SELECT @Reccount = 10
SELECT @BeginDate = GetDate()
SELECT @monthCount = (select datepart(mm, from_date) from equip_out)
SELECT @yearCount = (select datepart(yyyy, from_date) from equip_out)
WHILE @loopCount < @Reccount
    Begin
     INSERT INTO Equip_out (ID, Equipment_ID, From_date) VALUES ( (@ID_Max + 1), 'T1',
     ltrim(str(@monthCount)) + '/' + ltrim(str(@dayCount)) + '/' + ltrim(str(@yearCount)) )
     SELECT @loopCount = @loopCount + 1
     SELECT @dayCount = @dayCount + 1
     IF (SELECT DAY(DATEADD(d, -DAY(GETDATE()),DATEADD(m,1,GETDATE())))) < @dayCount
         BEGIN
         SELECT @dayCount = 1
         SELECT @monthCount = @monthCount + 1
     END

End