dfsfsdf

[iislas]

Código SQL:

DECLARE @d1 datetime, @d2 datetime
SELECT @d1 = '20140421',  @d2 = '20140422'
 
SELECT datediff(dd, @d1, @d2) - (datediff(wk, @d1, @d2) * 2) -
       CASE WHEN datepart(dw, @d1) = 1 THEN 1 ELSE 0 END +
      CASE WHEN datepart(dw, @d2) = 1 THEN 1 ELSE 0
 

end