Database

DECLARE @startDate datetime
DECLARE @endDate datetime
 
-- note use of ISO8601 yyyyMMdd format - unambiguous
SET @startDate = CAST( CAST( @year AS varchar(4) ) + '0101' AS datetime )

-- Month is 1-based but we don't want to add anything for January
-- so we subtract 1 from the supplied month number
SET @startDate = DATEADD( m, @month - 1, @startDate )

SET @endDate = DATEADD( m, 1, @startDate )

DECLARE @startDate datetime
declare @nextdate datetime
DECLARE @endDate datetime

declare @tbl_date  table (mydate datetime)

set nocount on
SET @startDate = CAST( CAST( 2007 AS varchar(4) ) + '0101' AS datetime )

SET @startDate = DATEADD( m, 6 - 1, @startDate )

set @enddate=dateadd(m,1,@startdate)

while @startdate < @enddate
begin

--SET @nextdate = DATEADD( d, 0, @startdate )
insert into @tbl_date values (@startdate)
set @startdate=dateadd(d,1,@startdate)

end

select * from @tbl_date

nr1b wrote:

how to trigger a new trigger inside a trigger

declare @tempdate table(myDate datetime)
declare @date datetime
declare @enddate datetime

set nocount on

set @date = '01-Jun-2007'
set @enddate = dateadd(mm, 1, @date)

while (@date < @enddate)
begin
	insert into @tempdate values (@date)
	set @date = dateadd(d, 1, @date)
end

select  myDate, m1, m2, m3
from test
right join @tempdate
on myDate = [date]