Thanks. I will try this and will let you know.

Thanks everyone. Dennis no offense taken. I agree my code was sloppy.

Thanks a lot. That helped and I will definitely will be adhering to what you said.

Thanks Guru but that doesn't give me overall total and break down by days range

GilaMonster (7/13/2016)

---

1) SELECT name from sys.procedures

2) SQL does not keep history of this information. You'll need to set up an extended events session to track this going forward

3) Short term...

Finally realised that we cannot make changes to the linked report, like editing the column names. Work around is i made a copy of the base report on my local...

Thanks a lot Durga.

sample data

scheduledatetimerequesteddatetimeinspecteddatetime

7/23/12 7:30 AM7/23/12 9:27 AM7/23/12 9:27 AM

7/23/12 7:30 AM7/23/12 9:27 AM7/23/12 9:27 AM

7/23/12 7:30 AM7/21/12 7:30 AM7/21/12 5:28 PM

7/23/12 7:30 AM7/23/12 9:27 AM7/23/12 9:27 AM

7/23/12 7:30 AM7/23/12 9:27 AM7/23/12...

The data looks like this

scheduleddatetime requesteddatetime inspecteddatetime

2012-07-23 07:30:00.0002012-07-23 09:27:00.0002012-07-23 09:27:26.533

2012-07-23 07:30:00.0002012-07-23...

Thanks Lynn, i figured out that the problem is with the datediff function, where it is being more precise and hence when comparing the 3 sifferent dates its resulting in...

Lynn,

what should i look for in the data as all the dates are in a valid date format.

Thanks

Also Lynn when i execute the FUNCTION by itslef it running withput giving any dataflow error.

Thanks Lynn this is the FUNCTION:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

-- ===================================================================================

-- -- Description:Given a unique inspection number, this function returns an integer

-- ...

Thanks Lynn can you please elaborate in detail? This PACKAGE didnt fail until the last weekend. Also can you please tell me what the "dbo.FN_GET_INSPECTION_DURATION_SECONDS( ScheduledDateTime ,RequestedDateTime ,InspectionDateTime)" is suppoded...