Does this return any row on your server:

select * from msdb.dbo.sysjobs where originating_server_id <> 0

I do not understand why A2 is included but not A5. Are you able to reformulate the logic in different terms to help me figure this one out.

Thanks!

Hi

Here is my understanding, let me know if that works.

You have QUERY 1 that returns:

no nome ...

You can't query a remote server without specifying a Linked Server, you will get an error that server is not in sysservers.

Check for sp_addlinkedserver in BOL.

After that you should not...

Hi Kotlas

Open the properties from your linked server in SQL 2000, keep that window open.

Create a new linked server in SQL 2005 and arrange both windows side by side....

The section Beta Testing in this article adresses that exact concern:

http://www.sqlservercentral.com/articles/SQLServerCentral.com/62764/

Good question,...

In Steve's defense:

http://www.sqlservercentral.com/articles/SQLServerCentral.com/62764/

If the date is stored as a number it should not be this big!

declare @DateTest datetime

set dateformat dmy

set @DateTest = '27/01/2009'

select @DateTest

,convert(int,@DateTest) IntDate

,convert(decimal,@DateTest) DecimalDate

The int for your '27/01/2009' date is...

Added missing T1 alias in first query

;WITH TABLE_ONE AS (

SELECT ROW_NUMBER() OVER(ORDER BY INTFIELD, VARCHARFIELD, DATEFIELD) AS RN, T1.*

FROM TBL1 T1

),

MATCH_TWO AS (

SELECT T1.*

FROM TABLE_ONE AS T1 INNER JOIN TBL2...

Hi

If you connect to your SQL Server 2000 and go under Security / Linked Server, do you have any entry there, perharps something referencing your SQL Server 2005?

;WITH MATCH_TWO AS (

SELECT T1.*

FROM TBL1 AS T1 INNER JOIN TBL2 AS T2

ON T1.INTFIELD...

hi again!

The left join will include all records from first table even if no records match in the second table. All fields from second table are listed as NULL values...

hi rahydri,

To me what you described here is a Left Outer Join.

select column

from tableA

left outer join table b

on tableA.columnA = tableB.columnA

where tableB.anycolumn is null

I dont know your level of comfort...

hi

Look for STATISTICS IO in BOL and you will see it's returning information about the activity generated by your SQL query.

Number of pages read from memory, or disk, etc...

If I...

Using the test data I posted and your query Jack I am missing 3 time slots

08:45-09:00

09:30-09:45

10:00-10:15

But your join is much more straightforward, I guess a mix of our two queries...