keith_stramler (9/20/2011)

---

I understand, however, I work for the state and at this point in time, I do not have access to any other versions. There is talk of upgrading...

NJ-DBA (9/20/2011)

---

jared-709193 (9/20/2011)

---

I still believe that we are missing a bigger issue here. We are developers/admins who work within an interface that executes script very easily. We can...

Why do you have to do the grand total in the SP instead of the front end where...

Why?

On sql 2000?

Sql 2008 is only months away from end of support (assuming no extended contract).

I would really start learning on sql 2008 R2 if I were you.

This works on...

GilaMonster (9/20/2011)

---

No, it doesn't.

If...

Why can't you add the grand total once in SSRS or whatever tool you are using to show the data?

NJ-DBA (9/20/2011)

---

the one thing I would caution about using a dummy database is to watch out for GO statements...

for example, if you have

USE dummydb

select * from sys.objects

GO

select *...

Grant Fritchey (9/20/2011)

---

You've got a GIANT disparity in statistics between the two data sets. One estimates 3.7 million, the other estimates 174. Right there is the main point of difference...

Those darn clock skew errors :-D!

And by precises he means 100%.

In theory, even 99.999999999% equivalent can change the plan. Of course you'd be hitting a bit of bad luck here.

It's just a metter of...

SQL Kiwi (9/20/2011)

---

It depends. The average DBA can get by...

use this instead SUM(Fields!Untstopy.Value) and remove the first sum.

If that doesn't work google around a little bit, should be easy to fix now that you know the real issue.

GSquared (9/20/2011)

---

Gianluca Sartori (9/20/2011)

---

GSquared (9/20/2011)

---

Depending on your ANSI NULLs setting, it might try.

SET ANSI_NULLS OFF;

CREATE TABLE #T (

ID INT PRIMARY KEY);

INSERT INTO #T (ID)

VALUES (1),(2),(3);

SELECT * FROM #T;

MERGE #T AS...