With a PRIMARY KEY on telephone number using SQL 2012, both of these queries get me a Clustered Index Scan.

DECLARE @TempTab TABLE (PhoneNum VARCHAR(10) PRIMARY KEY);

INSERT INTO @TempTab (PhoneNum) VALUES...

Probably your best course of action is to post the exact SQL you are running along with the results you're getting just as I have done.

Are you running the queries I provided using the Temp tables as I defined? Or have you modified them to operate off your real tables?

When I run the second...

Just when you're convinced the first value...

Unfortunately I don't have a Skydrive account...

It is already declared in the code I provided. You need to do it before the first...

p.barwick (2/3/2014)

---

Hi,

Thanks for your hard work, it's appreciated. As it stands, executing that query results in:

[Err] 42000 - [SQL Server] Must declare the scalar variable "@N"

...

Can I send you the...

To the OP: Please specify precisely what your expected results are. Do not describe them. List out the rows you want to see.

I'm thinking this is a relational...

Not sure this is exactly what will work for you but it may be close. Note that I added a PN (STC3333) to see if it would put it...

Jeff Moden (2/2/2014)

---

Hmmmm... there IS a way to do this in a SARGable fashion (although fixing the column is still the best idea). I just need to know how...

The best advice you're going to get is that you should not be storing your billing month as CHAR(7). Instead, a better choice would be to store it as...

Very nice article Jeff and I put in my vote to bump the rating accordingly.

As it turns out, I ran across this problem early in my SQLing. I like...

Is the above exactly the way you want to see the output from the query?...

Are you looking for something like this:

WITH Supercessions (PartNo, PNPrior) AS

(

SELECT 'RTC5756','STC9191'

UNION ALL SELECT 'SFP500160','STC9191'

UNION ALL SELECT 'STC9191','STC2951'

...

+1 to Luis for your good/charitable mood and two excellent solutions.