Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Saturday, August 19, 2017

Exclude weekends

SQLServerCentral » Latest topics
Exclude weekends
Hi,

I need to have a calculated field called EndDate and it should exclude weekends from the calucation .

CREATE TABLE #Dates
(
StartDate DATE,
Duration INT,
EndDate DATE
)

INSERT INTO #Dates (StartDate,Durat

No comments: