GREAT answer... I'd also add that I'd avoid views of views (can become a little memory intensive, more difficult to trouble shoot, and if written incorrectly, will need one view...

Sure... until you have to do a calculation with both... then, as Remi suggested, it won't be possible to use an index even if both columns are indexed.

Just as a...

As suggested, do a search on this forum... there's a particullarly good and nasty fast function to calculate Work Days (week days,...

An it's pronounced like the steel rod that but in concrete... ree-bar... (translation... steel stick in the mud

No... but it sounds like you have... what'd ya come up with?

IMHO, views of views are a bit like writing functions that call functions... they sure seem useful until you need to troubleshoot...

Or... rewrite the stored procedure to be setbased instead of RBAR.

I just love it when they don't  

Very cool... thank you.

I did a bunch of experiments on several different machines (desktop, 4 cpu server, 8 cpu server, etc) about 9 months ago and the results are posted somewhere on this...

Serqiy, cool function... especially great for bi-monthly paydays on the 1st & 15th, etc.

Bellefso... this returns the first date of the current month... was in both Serqiy's and my examples...

SELECT

In a function, instead of (over simplified example)...

If someconda

set a variable to value 1

If somecondb

set a variable to value 2

..etc..

I use,

SELECT somevariable = CASE

WHEN someconda THEN value 1

WHEN somecondb...

I finally found one at

http://www.sommarskog.se/arrays-in-sql.html

Is your's any better?

I'm still looking for the function that will split a 2gb string on a delimiter, Serqiy... any chance of you posting it or the URL you got it from?  Thank...

I wondered when you were going to show up on this one