Datoberegning uden weekender

SQLServer 2000, 2005 eller 2008 ?

Det er SQLServer 2000

-baby

Så bliver det nok en lang smøre.

Hej du kan bruge denne statement:

DECLARE
    @StartDate DATETIME
    ,@EndDate DATETIME
    ,@CorrectedStartDate DATETIME
    ,@CorrectedEndDate DATETIME

SET @StartDate = '2008-09-06 17:58'
SET @EndDate = '2008-09-13 21:59'
SET @CorrectedStartDate = (
    CASE
        WHEN (DATEPART(dw, @StartDate) + @@DATEFIRST) % 7 = 0 then CAST(FLOOR(CAST(DATEADD(DD,2,@StartDate) AS FLOAT )) AS DATETIME) -- 0: Saturday -> forward 2 days, strip time.
        WHEN (DATEPART(dw, @StartDate) + @@DATEFIRST) % 7 = 1 then CAST(FLOOR(CAST(DATEADD(DD,1,@StartDate) AS FLOAT )) AS DATETIME) -- 1: Sunday -> forward 1 day, strip time
        ELSE @StartDate           
    END
)
SET @CorrectedEndDate = (
    CASE
        WHEN (DATEPART(dw, @EndDate) + @@DATEFIRST) % 7 = 0 then CAST(FLOOR(CAST(@EndDate AS FLOAT )) AS DATETIME) -- 0: Saturday -> strip time to reverse to midnight.
        WHEN (DATEPART(dw, @EndDate) + @@DATEFIRST) % 7 = 1 then CAST(FLOOR(CAST(DATEADD(DD,-1,@EndDate) AS FLOAT )) AS DATETIME) -- 1: Sunday -> backwards 1 day, strip time to reverse to midnight.
        ELSE @EndDate           
    END
)

SELECT DATEDIFF(mi, @CorrectedStartDate, @CorrectedEndDate)
  -(DATEDIFF(wk, @CorrectedStartDate, @CorrectedEndDate) * 2 * 1440)

1000 TAK! Lige hvad jeg manglede!

Hva... så bør der vel falde nogle point? istedet for de ryger retur?

Selvfølgelig, men hvordan gør jeg det?

Hvordan kan jeg give dig de manglende point?

Du har selv taget pointene her.

Men proceduren i http://www.eksperten.dk/faq#faq-5-3 kan bruges til at klare det problem.