Just to be sure... creating a view doesn't necessarily improve any performance and, if it's done badly, can be quite the performance hog.

Good thread. I like the sp_MakeWebTask trick.

Adi Cohn (12/30/2008)

---

If you do have admin privileges, then maybe you misspelled the database’s name. If the server was installed as case sensitive, the database’s name is also case...

Thanks, Anzio.

Heh... so which is it that you actually want? A running total, or a current balance for new rows... there is a slight difference.

GilaMonster (12/30/2008)

---

I don't agree with that....

Like I said, I'm curious... how many rows in the Course Reference table and any chance of you attaching the first 10 rows of the 10 million row file you...

A cursory overview (no pun intended) says that this is a hierarchical sproc and it uses a cursor and a whole lot of RBAR... lord only knows what the sprocs...

Heh... ya know? Thanks for the feedback, Jeffrey... Seems like the intent of Microsoft was to make things easier for folks that don't know how to do it in...

I was also looking at today's article on SSIS and what I think is a fairly simple import...

http://www.sqlservercentral.com/articles/SSIS/64766/

All I can say is "Good Grief"... it took this person a couple...

You'd have to shorten the lines in the code box you made... but you're ok.

I'm curious... how many rows in the Course Reference table and any chance of you attaching the first 10 rows of the 10 million row file you imported? I'd...

Bob Hovious (12/29/2008)

---

Calm down, Jeff. Have some Eggnog. Maybe a pork chop. 😀

I think the OP has abandoned us anyway. Don't know whether...

With the limited information I have from you, the best I can do is what I've already done. Perhaps it's time for you to post the actual update query.

Would you tell us what the error is, please?