Execution plan attached. Running SQL2000.

1900-01-01 03:15:00.000

1900-01-01 03:15:00.000

1900-01-01 03:15:00.000

1900-01-01 03:15:00.000

Execution plan attached. Running SQL2000.

The function below is used within a query to get the last 10 days data. The query runs very slow even though there are indexes on the table. Any ideas?

CREATE...

Hi LutzM,

How do I create a calendar table?

Hi Chris,

How do I create a date table? Here's what the function does below

CREATE FUNCTION [dbo].[fn_ConvertToBusinessDate] (@Date DATETIME) RETURNS DATETIME AS

BEGIN

DECLARE @RollOverTime DATETIME

SELECT @RollOverTime = [RollOverTime]

FROM [dbo].[ac_Estate]

SELECT @Date = CONVERT(VARCHAR(8),...

Thanks, that worked a treat.