"Office application does not quit after automation from Visual Studio .NET client[^]" from Microsoft's Knowledgebase. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

Yes, I did some testing, and it appears that the anonymous function still belongs to the page where it is created, although the function is not declared in the page. --- b { font-weight: normal; }

I guess he wants every third Sunday from the start date, not every third Sunday of the month. I had the same misunderstanding. But, I like your method better than creating a table with every date between now and some arbitrary future date. CREATE PROCEDURE RecurringDates_ThirdSunday ( @Start DATETIME, @End DATETIME ) AS DECLARE @curDt DATETIME SET @curDt = @Start DECLARE @t TABLE (GoodDate DATETIME NOT NULL) WHILE DATEPART(dw,@curDt) != 1 BEGIN SET @curDt = DATEADD(dd,1,@CurDt) END SET @curDt = DATEADD(dd,14,@CurDt) WHILE @curDt <= @End BEGIN INSERT INTO @t (GoodDate) VALUES (@curDt) SET @curDt = DATEADD(dd,21,@CurDt) END SELECT \* FROM @t --EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters

Make a function: CREATE FUNCTION dbo.GetPopTotal(@cParent varchar(50)) RETURNS int AS BEGIN declare @nTotal int declare @nGrandTotal int declare @cChild varchar(50) set @nTotal = 0 DECLARE childcursor CURSOR FOR SELECT DISTINCT child,pop FROM travel WHERE parent = @cParent OPEN childcursor FETCH NEXT FROM childcursor INTO @cChild, @nGrandTotal WHILE @@FETCH_STATUS = 0 BEGIN select @nGrandTotal = @nGrandTotal + @nTotal + dbo.GetPopTotal(@cChild) FETCH NEXT FROM childcursor INTO @cChild, @nTotal END CLOSE childcursor DEALLOCATE childcursor return isnull(@nGrandTotal,0) END Call it like this: select parent,child, dbo.GetPopTotal(child) + pop as PopTotal from travel --EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters