The only thing that might beat the method in the article would be to maintain a separate table with a list of accounts and the current balance (1 row each)...

That's EXACTLY what you are doing...

Why not just ignore the cost for Employees since they suffer no cost? That would cut the number of tables in half and also keep you from having to...

Peso (5/13/2008)

---

Here is a script for testing, Jeff.

...

I mean no harm in posting the results. I just find it interesting that different methods and approaches to this problem have significantly...

Try the Peso 3...

Just couldn't have said it any better than...

Heh... can't wait for the mess folks are gonna make in 2k8 with the separate DATE and TIME datatypes...

...and provided that the syntax of the query hasn't made it impossible.

Cenk OZPAY (5/13/2008)

---

CLR?

I have seen some performance advantages when used in scalar functions. CLR can be used when there is no corresponding T-SQL functionality like splitting a string by a...

Sergiy (5/12/2008)

---

Jeff, I believe you're ovecomplicationg the problem.

I would suggest:

1) create simple ReportTable

(

SeqNo smallint NOT NULL PRIMARY KEY,

ReportString varchar(8000) NULL

)

2) Populate this table with lines to be reported, lines...

If you really want it in a single query, create a function using the same technique. Your turn... why does it have to be in a single query?

Last half of the following article tells you how to do a "split". Just replace the ? with a \ in the URL, remove the first 7 characters, and...

robertcaustin (5/12/2008)

---

I want to initiate a Procedure and then return-continue execution. The reasoning behind this is to use SQL Express but because Express does not have an Agent I need...

I believe I'd start wtih the Index Tuning Advisor and then tweek from there.

First, the function you have uses a cursor/while loop and it's going to be relatively slow. See the following for a couple of tips how to do it another...