First, please provide the table structure information, and test data via "CREATE TABLE" / "DECLARE @TableVar TABLE" and "INSERT" statements (see the first link in my signature for how to...

Based on what Lowell started, how does this work for you?

select case convert(tinyint,PARSENAME(convert(varchar(20),SERVERPROPERTY('productversion')),4))

when 8 then 2000

...

Chim Kalunta (2/23/2010)

---

It would appear that the clause:

inner join WhitePage w on w.displayname = a.displayname or w.eid = a.eid

is forcing a Clustered Index Scan on the Whitepage table. Thats where...

You mean there's...

You might want to check out this article[/url]

FYI, if your data would ALWAYS have 3 periods in there, you could use the ParseName function to return the position that you wanted.

i.e.:

DECLARE @x VARCHAR(80)

SET @x = '400.367.369.379'

select PARSENAME(@x,...

Thanks for responding back on how you resolved it.

Very good article Tim.

and might I add to the congratulate...

That would be...

CirquedeSQLeil (2/24/2010)

---

WayneS (2/24/2010)

---

FYI, Gianluca's unpivot works the fastest on my system (813ms), though Lynn's is right behind (833ms) - initial runs. But, when run repeatedly (and randomly), they actually flip-flop...

You will only need one of those where conditions, but you will need all 4 in the join between the tables. The query itself looks fine.

You should also test whether...

FYI, Gianluca's unpivot works the fastest on my system (813ms), though Lynn's is right behind (833ms) - initial runs. But, when run repeatedly (and randomly), they actually flip-flop back and...

Tom, I think that the "<" and ">", when inside the sql code window, get converted into xml tags: "& lt;" and "& gt;" (without the spaces). I'll bet this...

But Paul.... I'm serious!

BTW, I know you've told me before how you get the...

Yes, you can use it.

But let me show you why you shouldn't.

First, let's create a test table...