Like I said in my post above, Mahesh... be real careful. One big group of AccountNbr's and that triangular join you made will crush the server.

Just remember... you must include the columns in the GROUP BY that you intend to join on. If you return a heck of a lot of rows in the...

http://www.sqlservercentral.com/Forums/Topic672929-145-1.aspx

Beware the easy way... it's a trap... see my post on the thread above.

Ok... first of all, take a look at the following link to see why a thing called Triangular Joins are bad... real bad...

http://www.sqlservercentral.com/articles/T-SQL/61539/

I'd post the link to the "running totals"...

Good enough... gimme a few minutes to hammer it out...

Oh yeah... almost forgot... I'd cancel that meeting...

Tony (3/10/2009)

---

I'm crying from laughing! GilaMonster, the SQL book upside the head has already been considered - we're just trying to determine which book in our vast library here...

tvanharp (3/10/2009)

---

Thanks, That's what I decided to do.

It would be nice if I could make better use of the error handling, logging, and auditing that we've already buillt into SSIS...

Heh... understood. And I agree with Micheal, it would have been better if you posted your question in the...

Giovanni (3/10/2009)

---

Ok, guys: here is the issue; we are using SQL 2008

We have a table named SYS_BusinessObjects wich contains some information that is common to all tables in db and...

Ya gotta trust me on this... perfectly up to date stats and indexes just aren't gonna help this one. Try the pre-aggregation I spoke of... you'll be amazed.

Heh... if you want more people to look at it, post it in a format more people have. I sure haven't spent the...

adams.squared (3/10/2009)

---

i am not designing a table or a database. the problem was not how the table was designed. the problem was how to use the tables that i...

Heh... ya just gotta know what the next question on this will be... 😉

LoveSQL (3/10/2009)

---

Hi,

Can some one help me writing the following query?

Update the Seq numbers in the table below. Seq numbers must be ordered by their CreateDate and reset for...