But for client 1 your sample data is summing that column with the cumulative column.

I just noticed that you have two different formulas occurring in your sample data as well. For Client 1 you are summing (correct based on cumulative) and for client2...

vijay.s (5/6/2010)

---

Hi good folks,

I'd appreciate some expert assistance on this.

I am looking to produce the third column given the first two columns in

straight SQL without using cursors. Here is a...

praviii... (5/6/2010)

---

hi could any one suggest me the edition that should be installed for working on sql server 2008 at work.

different editions available

1.developer

2.standard

3.enterprise

4.web

5. workgroup

and also the platform which i shouls...

I think you will get great mileage out of reading an article by Jeff Moden on the subject.

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

Jack Corbett (5/6/2010)

---

Steve Jones - Editor (5/6/2010)

---

Top Ten Posters in this thread (out of 15,100 or so)

Jack Corbett 1533

Jack Corbett ...

As Paul said, this really isn't too big of a database. Knowing your big tables and where your sticking points are when doing the maintenance would be the keys...

PaulB-TheOneAndOnly (5/6/2010)

---

About two years after starting working with Oracle is when you will start to realize how different are SQL Server and Oracle implementations of the same basic principles.

Question is,...

I think you may have an Issue with Spotlight. Those page counts for the Spotlight spid are quite high. It has caused the system to allocate 4.7Gb of...

If we go the chili cookoff rather than nacho route, I...

That is a great tip.

Sour Cream

Lynn Pettis (5/6/2010)

---

Jeff Moden (5/5/2010)

---

Something that people either aren't aware of or have forgotten... the option of in-house training by the resident experts is a powerful tool that's frequently...

Not fully sure if it will work. MS recommend using Outlook 2000 for a few bug fixes when using a MAPI client - even for SQL 2005.

I think the...

rafael_si (5/6/2010)

---

Hi guys!

I work in a company here in Brazil, and we have a Data Warehouse. Well, at the beggining was easy to mantain this database indexed, because it was...