You have 3 tables involved in your UPDATE query.

1 is the target of the update (#Tmp)

2 are the source of the data to be updated (GE_Claim and GE_Reserve).

All three...

Select 'The Same'

Where 'test' = 'test     '

>>so you replace the apostrophe in  Hunter's with double quotes?

No, you replace the embedded single quote with two single quotes, not 1 double quote.

The syntax is incorrect, you aren't correlating the table being updated:

Update T

Set ClaimNumber = c.ClaimNumber,LastName = c.LastName,FirstName = c.FirstName,LossDate = c.LossDate,InClaimFile = 1

From #Tmp As T

Inner Join...

Is this a true partitioned view, in which the underlying tables have a check constraint on the partitioning column or columns ?

Does the package have a Dynamic Properties task or ActiveX Script task that execute prior to the Execute Process Task ?

If so, have you verified that neither of these are...

Here's an alternative. Not saying it's better, it may perform better on large datasets. It uses a derived tables which sets bit flags to indicate if certain conditions are met...

>>havent got time to go through books and stuff

Unbelievable. Really. Unbelievable.

You've applied for a job that you don't have the skills for, and you're using the time & effort of...

Open SQL's Books On Line (aka BOL)

Search for keyword 'Backup'.

You'll find the syntax and options for Backup Database

AND (Month_of_file = '20060901')

The SQL parser is telling you it doesn't know which Month_of_file you mean.

Did you mean GE_Claim.Month_of_file ?

Or did you mean GE_Reserve.Month_of_file ?

Stored procedures typically encapsulate some SQL operation - they way you're using them to 'dynamically' add to the WHERE is not their intended use and will lead to horrible performance.

It...

Use a temp table to assign a "rank" to records based on whatever sort order you need.

Join this to itself via a derived table, to include only items of a...

Create a temp table that matches the sproc's resultset columns:

Create Table #Output (

  Column1 datatype1,

  etc

)

Insert Into #Output

exec sp_myprocedure

Select *

From MyTable

Where MyCol IN (Select SomeCol From #output)

And of course, in...

>>So, if you are SELECTing data from Table1 where a matching row is

>>not found in Table2, a NOT IN is better than a NOT EXISTS

Not true.

What if the unique...

You're mixing data requirements with presentation requirements.

What if you fill your database with formatted phone number strings like this, and then the requirement for how the dta is presented changes...