Kenneth Wilhelmsson (10/18/2007)

---

So, what's the deal with not having a dates table?

It will solve all your problems, no need for complex functions or anything else exotic.

The main problem: How do...

the first solution didnt work. because of the Tally i didnt implement...

ps.

meanwhile the client "revised" some specs, so i do need these numbers now. but i still need to pull...

Absolutely spot on, Grant!

... and, we have to help "application developers" learn how to program in T-SQL 😉 Although CLR's are helpful for those that don't really know T-SQL or set based...

PS... can you be a bit more specific on what you're UDF does and post the code? UDF's are inherently NOT set-based... might be able to show you a...

Yeaup... that would also be one of the problems...

Change the EXISTS to a regular join on a "derived" table or a normal table and see if things don't pick up...

Heck no... there are dozens of slower ways to do it :D...

Max Yasnytskyy (10/17/2007)

---

Thanks for pointing out, as i didn't realize what server version this will run on.

I haven't ever used SQL Server 7 fortunately or unfortunately but what is wrong...

Andras Belokosztolszki (10/17/2007)

---

Search for "running total" or "running balance" on these forums.

Basically to do this in SQL and calculating this in queries is very inefficient and does not scale. You...

Yep... you should try it 😀 Works well on a lot of things and the guys...

mrpolecat (10/17/2007)

---

Tally is a table that you need to create with the column N. The fill it with the numbers 1 to whatever you think you need. This...

Ummm... this is an SQL Server 7/2000 forum... wanna tell us how well...

Depends... index scans can be worse than a table scan because even after the index scan, it still has to get the data.

The EXISTS with the sub-query, probably a correlated one at that, needs to be replaced with a join.

So... you've never seen recursive CTE's? You just don't need to use a CLR for such a thing... the tools are in T-SQL... you just need to learn to...