Sorry about the SET @@ROWCOUNT, brain was on automatic pilot.

Anyway with regards to previous you will do nothing more than create a continual loop on the first bits of...

I created a table in Northwind named x with an extra Idenitity column and this worked just fine no matter where the extra column was in my table that was...

Look at each execution plan as well to see if it uses an index to get it's data as opposed to the table or clustered index. Or if they are...

As is in SQL to offer the data you cannot unless you are not showing for all the ouput at all.

No and from your query I don't think SET @@ROWCOUNT will help either.

First I will have to assume all AddressNumbers are > 0 anyway. So try this

WHERE

F06136.YZDTEY >= @FromYear

AND F06136.YZDTEY <= @ToYear

AND (F06136.YZTARA = 'FEDERAL')

AND (F06136.YZPTAX = 'C')

AND (F06136.YZAN8 >...

Use OPENQUERY

SELECT * FROM OPENQUERY (LINKEDSERVERNAME,'SELECT GETDATE() AS CUR_DATE')

Try installing the latest MDAC from Microsoft under the site http://msdn.microsoft.com/data/Default.aspx on the machine where this is occurring or the server.

FOr your situation unless you build a middle ware app that can access at the switch and feed the info back then you setup a SQL instance for them on...

But Log Explorer will still not see Selects or Executions only logged events.

Your best bet is going to be Profiler in this situation.

Actually that cn be dependent on several factors including index.

Sounds like homework.

But the question I have is what is the table structure and what data would tell me the vehicle travels thru...

Should be, but look at the execution plan and see what it has decided the query as written would use for best performance.

It is considered better overall to use the join method.

The reason is it takes some work off the query engine with regards to decisiions it must make when trying to...

What version and Service Pack level of windows are you running?