I've seen it with to procedure scripts also (when scripted in EM). Happens when an object has been renamed (presumably a bug with EM's caching of object names ?)

Manually modify the...

Couple of comments on this ..

If the concern is underlying table changes impacting views, how are functions going to be any less prone to breaking if, say, a column name changes...

You're never going to be able to automate a process that requires user input to a GUI.

This is less of a SqlServer/DTS issue and more of a "make the EXE...

You need a sub-query to find max date by product code.

Then you need to join to that to pull the most recent BY PRODUCT

Select *

From YourProductTable As t

Inner Join

(

 ...

Hmm, only remaining thing I can think of then, is that the faster one is taking place as an "in place" update.

Sql Server can process an Update in 2 ways,...

In that case I'd construct it as an EXISTS, because you have a compound, 2 column natural key to check.

select s.suiteid As DeletableKey

from suites s

inner join buildings b

  on...

The relationship between Buildings/Suites is not clear. Can 2 different buildings have a suite with the same name ? Or is SuiteName always unique ?

Don't forget the LEFT JOIN rule - if you place a WHERE condition on any column in the left joined table, you essentially convert the left join to an INNER join.

See this thread in the MS newsgroups (apologies for the long Google URL):

http://www.google.ca/groups?hl=en&lr=&threadm=759DA088-AA28-4D4B-B420-690C28A8CE90%40microsoft.com&rnum=13&prev=/groups%3Fq%3Dbcp%2Btemp%2Btable%2Bgroup:microsoft.public.sqlserver.*%26hl%3Den%26lr%3D%26selm%3D759DA088-AA28-4D4B-B420-690C28A8CE90%2540microsoft.com%26rnum%3D13

To sum up, BCP with a Stored Proc executes the proc multiple times - first time with...

Sorry, got thrown by the thread title.

Without the full DDL of each table, tough to give an answer. What about Triggers & Check Constraints that reference the Date column being...

Add an "Execute ProcessTask" to your DTS package and in the proerties provide the name of you decryption EXE. Use workflow so that it runs after the FTP task is...

What about DRI ?

How many tables reference this PK that you're updating ? Remember, when you change a PKey, SqlServer has to check all tables that reference it to ensure...

Yes, but read the original post:

CREATE FUNCTION fnSelectTable(@TableName varchar(150))

RETURNS Table

AS

RETURN (select * from @TableName)

The design goal is to pass a tablename into a function and have it do something dynamic....

>>I'm having trouble using if...then because (best I can determine) you can only have two or at the most three options.

The code you published is obviously pseudo-code. Are you perhaps...

Since this requires a correlated update you should probably post the DDL of the tables and specify what keys join them together.

This (untested) SQL would handle the correlated update but...