Long story short, this sp was not the issue. We have another sp that is running without returning a result set. I am going to apply what you've...

Hi Jeff,

Thank you for the help. Much appreciated.

Steve

Hi Jeff,

Is this the syntax you were describing?

ALTER PROCEDURE bmssa.sp_VENDOR_ONTIME

/*

Vendor on time performance anaylsys

1/7/08 mm

*/

AS

DECLARE

@BeginDt Datetime,

@EndDt Datetime,

@Date1 Datetime,

@Date2 Datetime

SET @BeginDt = @Date1;

SET@EndDt = @Date2;

-- query 1

SELECT ...

Hi Jeff, Thanks for the reply. So I am declaring 4 variables and setting them to null prior to the execution? To wash them out?

DECLARE all four variables as...

Just the select statements.

Yes. the select statements execute timely outside of the sp. The issue is pinpointed to the passing of the date parameters in the stored procedure, since my other...

Here is an example of a stored procedure that passes a date parameter

ALTER PROCEDURE bmssa.sp_VENDOR_ONTIME

/*

Vendor on time performance anaylsys

1/7/08 mm

*/

@Date1 DateTime,

@Date2 DateTime

AS

-- query 1

SELECT LTRIM(PURCHLINE.PURCHID) AS...