Posted by Erland Sommarskog on 11/30/06 22:35

(paulmac106@gmail.com) writes:
> I utilize the Calendar table, and I'm able to find how many working
> days between 2 dates, but does anyone use this table to find the 2nd or
> 5th working date?
>
> if 11/30/06 then 12/4/06
>
> I'm sure it's not too difficult but i can't seem to get it to work
>
> (select caldate from calendar where...?...and workingday = 'Y')

If this is a common operation, adding a business-dayno column to the
table can be a good idea.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Inserting into a tmp table using a View --- Please help using SQL Query Analyzer
• Prev in forum: Re: Create SQL database with C#
• Thread view: Re: Find 2nd Working Day

[Reply to this message]