"Sister" table for the normally null columns... proper normalization of the table would be better.

Most of us get pretty ticked off about people that multipost...

http://www.sqlservercentral.com/Forums/Topic412362-5-1.aspx

So... add a CASE to the calculated column and you're done!

Partitioned view might be a possibility...

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...