Oooooo.... Erland Sommarskog,

???

Paul, I think you overlooked this from AJ's post in midstream.

Hi, yes I'm aware that this is not a numeric comparison. I guess my simplistic example was off the mark.

The...

From the "About The Author" section.

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1280004,00.html ...

I hope you found your way to a satisfactory solution.

Thanks for taking the time to send in your actual data. Plug those values into my example(s) above and you should see exactly what is happening.

The problem is about to go away. See Steve's Editorial for April 1, 2010.

Oh, and what is the capacity of your tempdb database? Have you checked it for IO stalls? If you, like so many of my clients, has an under-powered tempdb storage...

Whups.... there goes ROW_NUMBER(). Perhaps a temp table with an identity column to set up the variable number of columns in the result set? ...

How you can keep a "straight face" while writing is brilliant, Steve. 🙂

I didn't say *I* was going to sue you. I was encouraging STEVE to. 😉

Excuse us, AJ... private joke.

I still think greater than or equal to...

Anything for you, Jason, you copyright-violator, you.

FROM BOL:

http://msdn.microsoft.com/en-us/library/ms187489%28v=SQL.100%29.aspx

With respect to Glenn, this is nothing like a...

I agree with Michael:

In your example the numbers are varchar datatyped, not numeric. To find 10,20,30,40,50,...

Amended, with apologies to anyone who read the first draft.

It's a rounding error (of sorts) assuming the IDs are integers.

create table emp1 (id int)

create table emp2 (id int)

insert into emp1

select...

My guess would be "rounding". Post up your table definitions and your data and we can prove or disprove that.