http://aaronjohals.blogspot.com/2005/10/number-of-working-days-between-2-dates.html
http://classicasp.aspfaq.com/date-time-routines-manipulation/how-do-i-count-the-number-of-business-days-between-two-dates.html
drop function dbo.GetWorkingDaysDiff
go
create function dbo.GetWorkingDaysDiff(@start datetime, @end datetime)
returns int
as
begin
declare @countdays int
set @countdays = 0
while @start < @end
begin
if (select datepart(dw, @start)) < 6
begin
set @countdays = @countdays + 1
end
set @start = dateadd(d,1,@start)
end
return @countdays
end
GO
print(dbo.GetWorkingDaysDiff('2006/08/21', '2006/08/27'))
go
5 comments:
louboutin
lebron james shoes
golden gooses outlet
birkin bag
yeezy boost 350
nike shoes
golden goose shoes
polo ralph lauren
christian louboutin
kobe byrant shoes
replica bags from turkey replica bags wholesale india 7a replica bags
visit this page their explanation article see this site have a peek at this website see this page
jetez un œil à ce site Web sacs à dos de créateurs de répliques son dernier blog Dolabuy Chloe essayez ici meilleurs sacs de répliques
Awesome blogg you have here
Post a Comment