There is a problem in your problem definition.

" whatever dates that fall in between the admission date and discharge date will be ignored. However a patient could be admitted and...

Thanks for the fix, guys.

Used it like this (in case anyone else wants it)

WITH E1(N) AS (

...

My version of SQL (2005) does not seem to handle the "VALUES" in

SELECT TOP(DATALENGTH(@List))

n = ROW_NUMBER() OVER(ORDER BY (SELECT NULL))

FROM

(VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) d (n),

...

For a prettier output, prefix the product and scheme results with a space (' '+....)

Then you don't need to prefix the totals with a 'Z' as they will fall to...

Great article, thanks. I really enjoyed going through that.

I am looking for CTE's that will give me formulae for different predictive analysis routines.

here is a slight coding problem, the first...

Review by object name is easier, so order by "object name". (Order by 1 means order by the first column returned).

For those who are looking for an easier way out, I put together this sql that (hopefully) will identify the views that are older than the last table modify date,...