drew.allen (5/19/2016)

---

Rod at work (5/19/2016)

---

Just thought of something else to add to this. Years ago I was working with some other report generating product (I can't remember what it was...

Just thought of something else to add to this. Years ago I was working with some other report generating product (I can't remember what it was now), but I believe...

Yes Lynn, it does make sense. Thanks!

Lynn Pettis (5/19/2016)

---

Here is a simple way to swap two values to ensure StartDate is less than EndDate:

d e c l a r e -- spaced to allow posted from...

Great feedback, everyone! Thanks!

Marcia J (5/18/2016)

---

Steve Jones - SSC Editor (5/16/2016)

---

Rod,

I think many companies tolerate pain in deploying software. I have no idea why myself, but I'm more baffled as to why Developers...

I don't know, Steve. I agree with you in principle. But I notice, at least in my current position, that there is a very high tolerance for pain in how...

OK, I found the problem. I didn't realize it, but the report already had a sort order in it. So naturally even if there's one in the stored proc, it's...

Joie Andrew (5/6/2016)

---

Are the results from the stored...

Spiff (5/6/2016)

---

The project configuration mode mainly determines the deployment options for your project so shouldn't really affect this.

I'm slightly unclear about the issue now - is it the data itself...

J Livingston SQL (5/8/2016)

---

Rod did you run the test script I posted?

1 Million row table

-- update 6 columns on 100 000 rows

--run 10 iterations of update with trigger on

--then disable...

Oh OK, thank you, Jeff.

Spiff (5/6/2016)

---

SSRS caches report data as a .DATA file in the solution folder.

Either run the report again and click the little "Refresh" icon - this should force SSRS to rerun...

pietlinden (5/5/2016)

---

What happens when you run the stored procedure inside SMS, not SSRS? Is there a chance that you're connecting to a different server that has a different copy...

Jeff Moden (5/5/2016)

---

Wayne West (5/5/2016)

---

Good points. My biggest table has 66 columns (all the other active tables have a very small column count), but even when I was inserting...