Hello - thanks for your response.
Much appreciate it....
QuestionBoy
Last Activity: Jul 13 '10, 06:48 AM
Joined: Jul 1 '10
Location:
-
SQL Business Hours Calculation
Hello - I have the below function (source: http://ask.sqlteam.com/questions/110...urther-queries) that basically calculates the business hours/minutes elapsed between two **smalldatetime** fields:
...Code:set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER FUNCTION [dbo].[getBusinessHours] (@smalldatetime1 smalldatetime, @smalldatetime2 smalldatetime) RETURNS bigint AS
No activity results to display
Leave a comment: