You are joining on Vendor which is not the primary key/unique identifier of each row. This means you are updating more rows than you think, and you are updating each...

Enterprise Manager (EM)

Right-click on table name->All Tasks->Generate SQL script...

http://www.google.com/search?hl=en&q=ddl+database+acronym&meta=

The CREATE TABLE statements for the objects involved. These will show the datatypes of each column. The datatypes will include the length, then we can easily spot cases where...

This is why you often see this in the forums:

"Please post the DDL of your tables"

You are getting this because a character column in your destination table isn't large enough...

What does the "copy function" do ? It's possible that it's generating an error with a high enough severity that it can't be trapped by checking @@error, therefore the entire...

It's not really an INSERT then, like the thread title suggests ? It's a correlated UPDATE ?

Update A

Set Qtr = B.Qtr

From TableA As A

Inner Join TableB As B

  On (A.Col1...

Insuffient info.

Is the ID column always in ascending & sequential date order for each employee ?

What if Peter Jones' data had ended in an "In" ? Would you expect 4...

Which "query designer" ?

CASE is legal T-SQL and you can use it in views, so you shouldn't let a UI based designer flaw influence your view definition.

CASE ... WHEN ... END is the T-SQL equivalent to IIF()

CASE

WHEN FileName = 'Retail' THEN NumberOfRecords

ELSE 0

END

>>I do recall hearing or reading somewhere that performing an INNER JOIN after a LEFT OUTER JOIN could potentially return obscure results

Nope, I think what you heard is that...

>>Contrary to what was stated earlier there is extra overhead to checking the existence before the delete. 

Indeed there is. But also contrary to everything stated earlier, I don't think a single 1...

Run SQL Profiler. Set it to trace all T-SQL activity and apply a filter on the database name so that only this 1 database gets profiled.

Just select it into the @From variable prior to setting the property. However, you also still have @From in the parameter list of the stored proc, so you need to...

This is a known DTS problem that I stumbled across 2+ years ago and I've never seen a fix for it. It occurs if you use an Execute Sub-package task,...

In that case, you need a LEFT JOIN.

Looking at your original post, you did use a LEFT JOIN, but with 1 problem - you placed a WHERE clause on the...