Something like this....

Create Table Calendar

(

DateCol datetime Primary key,

DayNo tinyint)

go

with cte

as

(

Select top (3000) Row_number() over (order by (Select null)) as RowN

from...

scott.pletcher (6/22/2010)

However, as I understand it, for a single statment, the entire string must match exactly for SQL to reuse the plan; even mixed case in a keyword or extra...

Why (other than curiosity ) ? It seems a lot simpler to me to...

Going from a Left Outer Join to a Full outer join is not a trivial change and is a completely different piece of work.

Post the Execution plan and DDL for...

The "quirky update" method is based on the assumption/fact that the simpe query is always retrieves or operates with data in the order of the clustered index by default.

I tend...

Dont take this the wrong way but from here it is very difficult to judge a persons skill level.

Are you aware of what an index is and how and why...

Ideally you should modify your tables so that and the IPAddress type columns are of the same type, bigint would be best IMO.

You need indexing though. try

Create Unique Index...

No Indexes ?

Indexes and DDL as well please

Please post DDL Etc as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Are you saying you have an example where it doesn't sort correctly ?

Any multiple...

Something like this ?

with cteRows

as

(

Select Row_number() over (order by IdRow) as Rown,

SG300,

SG500,

...

Have you tried the Ordanance Survey Site ?

https://www.ordnancesurvey.co.uk/opendatadownload/products.html

correct information ????

What doesnt ?

Looks pretty good, one sort in there which *could* be removed by adding ( or extending by including) an index.