Confirmed.

Thanks

Thanks Gift for your reply.

I read your post and tried to enable the three options, however, file stream couln't be enabled. When clicking the Ok button the Properties dialog is...

Thanks Steve, they were really useful and provided me with what I needed.

CREATE FUNCTION [dbo].[GetWorkingDays]

( @StartDate datetime,

@EndDate datetime )

RETURNS INT

AS

BEGIN

DECLARE @varDate datetime --placeholder for c

DECLARE @wdCount int

SELECT @wdCount = 0

SELECT @varDate = @StartDate

WHILE (@varDate Between @StartDate...

It's SQL Server 2005

Actually the businees rule needs to insure that only one record for a period of time, so if there is a record for the same period it will return 0...

Table structure:

[Record_Id] [int] NOT NULL,

[From] [smalldatetime] NOT NULL,

[To] [smalldatetime] NOT NULL

Data:

Record_Id FROM ...

Editor's Note: Link removed.

Look it up at 4Shared & eSnips. You'll find many.