My error. I wasn't thinking of combinations of single elements.

Recipe number 7 looks a lot like recipe #1 to me... This problem seems oddly familiar though.

You didn't mention how big your table was (number of rows.)

To see some performance comparisons of different techniques dealing with a similar problem.

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

It's just a personal preference. I just feel happier summing ones and zeroes, than...

One approach is to use SUM(CASE...) in place of COUNT().

The trick is to make the test for an earlier Trans_Type = 1 quick. Depending on the...

Forget the object_ID. You need to know the object name for a table_source in the SELECT ... FROM.

I can think of two approaches...

Brandie: Congratulations for the story AND congratulations for getting to do work that you love.

I don't believe this should be done with set-based coding. You are essentially slicing up an ordered set of row into 3k chunks ( or "tiles" as...

SQLRNNR (4/28/2011)

---

Stefan Krzywicki (4/28/2011)

---

The Dixie Flatline (4/28/2011)

---

SQLRNNR (4/28/2011)

---

Ah suds, I better timewarp to get that new update so I can come back to the present, upgrade my timewarp and then...

SQLRNNR (4/28/2011)

---

Ah suds, I better timewarp to get that new update so I can come back to the present, upgrade my timewarp and then run the new version with the...

Jason, it's easy.

Use DBCC TimeWarp's

New parameters.

Haiku

Listen... can you tell?

Someone is using cursors.

Hear the pork chops fly!

I think that was the point behind his question, Stefan. Why would he ever need to make a computed column persisted?

In this as in all things, it depends.

You are correct. If your query is using a covering index then the data isn't coming from the clustered index....

Did you deliberately comment out @RunningTotal in your FETCH...INTO?

FETCH NEXT FROM RunningTotalCursor

INTO @conta,@docnome, @u_subconta, @data, @mlstamp,@dinome, @adoc, @dilno, @edeb, @ecre, @NomeCli--, @RunningTotal