SQLUSA

Microsoft SQL Server 2005 Best Practices

 
The future is just a click away! Your future!
How to create a weekly pay period calendar?

 

Execute the following script in Query Editor:

USE AdventureWorks
GO
CREATE TABLE HumanResources.PayCalendar( ID int IDENTITY not NULL,
WeekStart char(10) null, WeekEnd char(10) null)
GO

INSERT HumanResources.PayCalendar VALUES('2005/06/19', '2005/06/25')

WHILE (SELECT MAX(WeekStart) FROM HumanResources.PayCalendar) <= '2021/01/07'
BEGIN
INSERT HumanResources.PayCalendar
SELECT CONVERT(char, DATEADD(day, 7, MAX(WeekStart)), 111),
CONVERT(char, DATEADD(day, 7, MAX(WeekEnd)), 111)
FROM HumanResources.PayCalendar
END


 

The World Leader in SQL Server Training
 
SQLUSA.com Home Page