RE: Better Way to Perform this Query

Jeff Moden

SSC Guru

Points: 1003894

January 9, 2013 at 9:54 pm

#1575573

Alan.B (1/9/2013)

AndrewSQLDBA (1/9/2013)
Its worth noting that the following is sargable.
LIKE '%abc%'

Did you mean "NOT" SARGable because it sure doesn't look SARGable from here. 😉 And, I agree... nice use of NTILE.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)