Thanks for an easy, back to basics question.

Don't feel bad, I had to Google it to be reminded of...

I do not like to be a kill joy but the MEDIAN is defined as:

median of a distribution with a discrete random variable depends on whether the number of terms...

I suggest you visit this site, and there you may find a solution to your problem.

http://www.sqlsharp.com/

Or read this article on SSC

http://www.sqlservercentral.com/articles/SS2K5+-+CLR+Integration/3208/

One possible method is to use a temporary table for example:

CREATE TABLE #T(Id INT IDENTITY(1,1),Tname VARCHAR(100),NumRows INT,RowsMod INT,Rspace INT, Uspace INT, StatDate DATETIME)

INSERT INTO #T(Tname,NumRows,RowsMod,Rspace,Uspace,StatDate)

SELECT -- remainder...

Check out Redgate software

http://www.red-gate.com/

Revenant (7/13/2012)

I am curious...

Here is a link posted by Steve Jones on 12/31/2007 12:43 PM

http://www.sqlservercentral.com/Forums/Topic437598-324-1.aspx#bm437640

which in turn contains this link:

http://technet.microsoft.com/library/Cc966393

With no workload governor, there should be no limit as far as the database...

Very easy QOD ... but then wondered, what is the gimmick, what am I not understanding ... after reading it about 10 times I concluded no tricks, nothing hidden just...

To gain another perspective, and method to "refresh/update" the views meta data may I suggest looking at an older QOD at:

http://www.sqlservercentral.com/questions/Views/88916/

What happens behind the scene, so to speak, is shown...

It appears that Level 6, Level 7, and Level 8 have yet to be published. Other than attempting to contact the author and asking i guess we just sit...

And may I thank you for letting me know that I may have been of some benefit... too often those who are helped do not acknowledge the help given.... so...

Why do you need a case statement ? When something like this will produce the results you have indicated that you require.

CREATE TABLE #T(theStringis VARCHAR(50))

INSERT INTO...

Nice to be reminded of the basics

This might be what you require.

CREATE TABLE #Address(HomeAddress VARCHAR(75))

INSERT INTO #Address

SELECT '13480 lone point lane' UNION ALL

SELECT '4420 Douglas...