I updated the stored procedure to load the sql statement into a temp table and everything seems to be working fine.  thanks everyone for the help.

Most of my work is...

Try converting the SP where clause to this:

where CONVERT(datetime, sd.gldate ) >= @@StartDate

and CONVERT(datetime, sd.gldate ) <= @@EndDate

I tried the above change and it gave me that same results.  I also tried...

Thanks for all the input - I will try each and see which one works best.

The only thing the stored procedure does is declare and set the variables used in...

The largest table has about 8 million records, the others are less then several thousand records.  The SQL statement returns approx 3,000 records with the passed date ranges of one...

Thank You - Perfect

Jedi