If you cannot make inner join to the table where all your data stored then what do you want to work with?

Update r --GE_ReservesFile

Set ClaimNumber = c.ClaimNumber,

LastName = c.LastName,

FirstName = c.FirstName,

LossDate = c.LossDate,

InClaimFile = 1

From GE_Claim c

   Inner Join GE_ReservesFile r ...

Utherwise you update not the...

Probably it's for good.

SUBSTRING works a little bit faster.

select REPLACE(STR(5, 2), ' ', '0')

"5" is a result of your DATEPART function.

Are you sure?

Did you run EXACTLY the same code as you posted?

This will appear only when you run an SP from QA:

IF APP_NAME() = 'SQL Query Analyzer'

PRINT 'whatever'

1) INNER JOIN tables ON " three have a match "

2) WHERE DateAdd(yyyy, 10, EffectiveDate) < LossDate

What's stopping you from debugging the code without encapsulating it into UDF?

Do it in QA first, test performance, check execution plan, and when you are absolutely happy with it add...

When you have 2 remote tables in the same query you copy both tables to the temporary location. You copy entire tables.

Than you process the query not having any indexes...

declare @tm int

set @tm = 181533

select dateadd(hh, @tm/10000, 0)+dateadd(n, @tm/100-(@tm/10000)*100, 0)+dateadd(ss, @tm-(@tm/100)*100, 0)

And I'll be long dead.

1. Don't use remote queries. At least avoid them if posible.

Use OPENQUERY.

2. Don't use remote query in subquery. Just don't do this. Ever.

Unless you use to teach students in University...

set @filename = 'BULK INSERT #textfile FROM ''D:\websites\neolane\www\Import\mvt_' + convert

Procedure is just procedure. Do you know the meaning of this word?

It's not a table, not any other type of object.

What would you say about developer who's trying to use...

Same phone number will be dialed (that means appeared for the user) in different ways from different locations.

Unless you mean to limit usage of your application to a single town you...