Spam reported.

You need PERCENT_RANK which is not available In SQL 2012.

To get the Percent Rank Pre-2012:

If rk is the RANK for the specified partition

AND rc is the row count for...

Thank you for checking it out.

Kristen-173977 (9/16/2015)

---

Very useful function, thank you.

Hopefully not a stupid question?!! but is there is reason why this is a table-valued function rather than...

Cool idea... I'd happily contribute.

I'm a little late to the party but let's not forget about PatExclude8K[/url].

Here's two Patexclude8K solutions:

SELECT Data = NewString

FROM #Tab

CROSS APPLY dbo.PatExclude8K(data,'[= 0-9]');

SELECT Data = NewString

FROM...

mister.magoo (9/15/2015)

---

You can also improve on that a bit Alan, it won't scale at all well (try it for a sample of 700 rows)

I would always try and keep a...

You can simplify your query like this:

IF OBJECT_ID('tempdb..#Table') IS NOT NULL DROP TABLE #Table;

CREATE TABLE #Table ( MAIN INT,SUB1 INT,SUB2 INT,[STATUS] VARCHAR(10),MODIFIED VARCHAR(10))

INSERT INTO #Table(MAIN,SUB1,SUB2,[STATUS])

VALUES (1,2,4,'Valid'),(2,4,5,'Valid'),(3,6,4,'Valid'),(4,2,1,'Valid'),(5,3,4,'Valid'),(6,0,0,'Invalid');

DECLARE @count INT =...

I've seen this since 6.5 or 7.0 and it's still my favorite error.

What have you tried so far?

I was a DBA from for a few years and have since moved on to Business Intelligence.

There seems to be some debate about this but, from what I've seen,...

FYI regarding my post. I am using SSMS 2012 but got the error on a 2014 server (probably would have been more appropriate to post this under 2014).

brad.mason5 (9/11/2015)

---

I...

Thanks Eirikur, you always seen to have the answer. Very interesting stuff - I have never really played around any Undocumented Query Optimizer Trace Flags (I used to play around...

If a recruiter wanted to see some of my code without any explanation I would blow them off. I had some take home...

The Gail Shaw book Jacob recommended is great.

An appropriate follow-up question is, "Why do you ask?"

Everything Koen said, especially the Itzik Ben-Gan books.

I would add:

Kimball's The Microsoft Data Warehouse Toolkit, 2nd Edition[/url] is essential for any new BI developer. That's my BI bible....