John,

I have added linked Server S with report server. Can you please give an example of what would be considered as a fully qualified code.

Also when I write the code...

Thank you Luis, I will try this tonight and let you know if it works.

Does anyone have any ideas or suggestions?

The following is the step 1 on the job on Server S

SELECT LoanID

FROM ACHWebPayments Where (DraftDate > CONVERT (date, GETDATE()) and exported is null) and (DateRequested > CONVERT (date, GETDATE())...

Thank you

It happens to work with FS3 which is FS3(SQL Server 10.50.2550)

Now the problem I am facing is with Security:

Under local login I am putting myself (DMG\abc) should I check impersonate...

Thank you guys. I tried the GUI way SSMS and get the following error when I click ok:

--> SQL server native client 11.0 doesnot support connections to SQL server 2000...

Thanks , yes you are right when I ran the following query on DSQL it only listed itself, there was no FS1 or FS3

SELECT * FROM sysservers

I have never added...

I ran the following under DSQL master:

EXEC ('select 1') AT FS1

still getting exactly the same error:

Msg 7202, Level 11, State 2, Line 1

Could not find server 'FS10' in sys.servers. Verify...

Yes there are approx. 200 records where Berry needs to be replaced with Larry.

I apologize I didn't mean any disrespect. I think I finally got it, you are right there was no need for me to join the same table again.

Again thanks for...

Luis, still doesn't work,

lets take this example and make it simpler; consider the following code:

WITH History_CTE

AS

(

SELECT loanID, HistoryCounter

,ROW_NUMBER() OVER (PARTITION BY LoanID ORDER BY HistoryCounter) AS [Dense Rank]

FROM History

WHERE TransactionAmt...

Would anyone else know?

thanks again,

the reason for CTE is because I only want to display loans where there HistoryCounter has a dense rank of 1.

According to you if I use the following in...

Thanks Zartin

I did the following, rest kept the same, I am guessing my select statement is still wrong,please advise

Select

,(Select H1.[Dense Rank] from H1 WHERE [Dense Rank] = 1)

JOIN

LEFT OUTER JOIN...