There is no security in obscurity.

Post it.

Of course, the order problem can be easily remedied if you just add an Identity column. 🙂

SELECT distinct R1.FlightNum, R1.ToCityCode, R2.FromCityCode

FROM Flights R1,...

Uuuhh, ... "Big Stupid Old Fart-Head"?

This should work:

;With cteTable1 as (

Select Row_Number() OVER(Partition by Prod Order by 1) as Row

, Count(*) OVER(Partition by Prod) as Cnt

, Prod

, Description

From table1

),

cteIterate as (

Select Row, Cnt,...

Make sure that you have the latest release (RC0 or RC1?). And, make sure that it is installed on both the server AND the client (people always forget to...

You're close. your FROM and WHERE clauses are fine.

The problem is that the 2 city codes that you are displaying are the same 2 city codes that you are...

Likewise, Jeff!

Right. Similar to what I was thinking of: somehow you have to get that code over there in the first place to handle it for you.

I cannot think of any way that you can do this, without installing some software or service on the remote server. I think that you will have to connect...

However, without a Clustered Index or an "Order BY", these rows could still come back in any order.

Thanks for the feedback, Brian

Glad I could help.

Hmm, I've got a QotD coming out next week and I'm afraid that my answer here, might give it away. Oh, well, helping is the first priority... 🙂

You are...

The is_disabled column of sys.foreign_keys?