Viewing 5 posts - 1 through 5 (of 5 total)
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...
October 5, 2004 at 8:45 am
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...
October 5, 2004 at 8:23 am
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...
October 5, 2004 at 7:45 am
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...
October 4, 2004 at 12:29 pm
Viewing 5 posts - 1 through 5 (of 5 total)