It might be in the list (and is often quoted as unsargable), but sargability surely must be defined by behaviour; hell, the nonsense name is derived from a description of...

Gianluca Sartori (10/12/2010)

---

I see the point you're trying to make, but "column IS NULL" is not a SARGable predicate.

The index CAN be used anyway, but this doesn't make the...

Gianluca Sartori (10/12/2010)

---

For instance, these are one SARGable expression ( REVROLE_ROLEREVU_REVIEWERROLEID.NAME LIKE 'LE REVIEWER%') and a non-SARGable expression (CARE_BOOKSERIES.Id IS NULL...

WHERE CARE_BOOKSERIES.Id IS NULL AND REVROLE_ROLEREVU_REVIEWERROLEID.NAME LIKE 'LE REVIEWER%'

The answer to that could fill a book. I saw Conor Cunningham at SQLBits earlier in the year - his presentation was a very good overview:

http://sqlbits.com/Speakers/Conor_Cunningham/Default.aspx

To answer the...

Super - that's cracked it then.

SELECT Column1

, perc = SUM(CASE WHEN Column2 = 'No' THEN 1.0 END)/ COUNT(*) * 100.0

FROM ...

Do you mean you want John instead of Micheal because it appears "before" Micheal? If so, you are not in luck. Relational databases act on sets of data. There is...

The very simplest way is:

SELECT TOP 1

ID

, [DESC]

,...

My query was a brain fart - it isn't logically the same.

Remove spaces from these tags:

[/code ]

Looks the same to me but I didn't look really closely.

SELECT DISTINCT

SUBSTRING(CONVERT(VARCHAR(6), REPLICATE('0', 6 - DATALENGTH(LTRIM(STR(NAME_MASTER.id_num, 6))))

...

I posted a link in my earlier reply.

pjr001 (10/7/2010)

---

Hi

I have 2 tables, dispLookup and campaign.

The dispLookup contains 2 columns, Code and Disp.

The campaign table contains date, time, code000...code199.

The dispLookup table contains a nice name for each column...

I am rephrasing Paul's answer in a way that makes sense to me - ignore if you've already got it.

A foreign key is a constraint - it restricts the values...