Sounds like parameter sniffing. Please post the code for your stored procedure.

Mitch2007 (7/24/2009)

---

Good day all,

trying to track down why this simple CASE...

Should have also noted that the table in my query has 1,000,000 records as well.

Lowell (7/24/2009)

---

isn't Crystal still client-server based, so you have to install Crystal on every machine that will run a report, vs SSRS which is a web server HTML based reporting...

All my kids love to read. My middle daughter wants to be an author. She prefers fiction (sci/fi, fantasy) over non-fiction.

I can't really answer that question. We do use SSRS, but I'm not currently involved with it myself beyond using a few reports which we get to using the...

For edification:

where

[column_name] not like '%10BUC%' and

[column_name] not like '%UNCLGAD%'

is equivalent to

where

not ([column_name] like '%10BUC%' or [column_name] like '%UNCLGAD%')

Drop HyperBac another email and see if they'll send you an older version of the program to check out.

You do not need SharePoint to take advantage of SSRS. SSRS integrates with SharePoint allowing you to manage security from one place, SharePoint, if you so desire.

What version are you running? If you posted it, I can't seem to find it.

William Plourde (7/24/2009)

---

I have coded two sql select stmts that I though would be equivalent but have learned through observation that they are not, the issue now is that I...

Say good night Gracie.

I'm still running 3.0.11.0.

.,.,., why not let Jeff post the url? Others, like myself, may just benefit ... oh, you want to keep us in the dark, like mushrooms! 😛

george sibbald (7/24/2009)

---

total processor % jumps up about 25% to 50% average, speread evenely across the cpus (4)

Do the...