jcrawf02 (11/16/2011)

---

Ninja's_RGR'us (11/16/2011)

---

Koen Verbeeck (11/16/2011)

---

Ninja's_RGR'us (11/16/2011)

---

Koen Verbeeck (11/15/2011)

---

Ninja's_RGR'us (11/15/2011)

---

Same here.

No offense if I forgot anything else. I didn't reread the...

Don't hold your breath

slip

Also, I would alias the tables internal to the subquery and use those aliases when referencing the columns.

Does that AD account already have other permissions in the database under the dbo schema?

and wanting to live forever

In your subselect, you are only referencing tables from outside the subselect in your group by clause.

(SELECT SUM(dbo.ART_Exp_Records.Exp_Csm_Value)

FROM dbo.ART_Exp_Records

INNER JOIN dbo.ART_Exp_Sheets

ON dbo.ART_Exp_Records.Exp_Sheet_ID = dbo.ART_Exp_Sheets.Exp_Sheet_ID

GROUP BY dbo.ART_Consortiums.Csm_ID, dbo.ART_Exp_Sheets.Sheet_Year,...

I see that now in your original post - got lost in there

What is the error that you are getting?

harbor

It is when you can lay out a table of what the expected results should look like, that often times the solution becomes more apparent for you. It also...

Ninja's_RGR'us (11/15/2011)

---

Brandie Tarvin (11/15/2011)

---

EDIT: Nevermind. I see you were quoting them for Grant. DOH....

Thanks for pointing out that new article about data files on network shares. That looks interesting and worth a shot.

Grant Fritchey (11/15/2011)

---

Hey everyone. Back from the hole into which I crawled. Did I miss anything? And no, I'm deleting a few hundred emails rather than read through all this....

Thanks Ron.