Working hours between two datetime TSQL
As part of working out SLA’s by using the working hours between two dates we struggled to find a working solution, one of our developers built a nice function that does just that; SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].udctGetWorkingMins(@from DATETIME, @to DATETIME,@daystartmins INT NULL,@dayendmins INT=NULL) RETURNS INT AS BEGIN –…
Details