So the goal is to have a DTS package behave differently depending on certain runtime conditions ?

DTS in Sql2K is a little weak in this regard. You typically have an...

Where would you need to use this, where you couldn't just select from the table in a sub-query ?

Maybe the solution isn't to look for workarounds but to revisit the...

>>Is this not possible outside of creating a dynamic sql statement and using the execute

Correct, not possible. You need dynamic SQL if table name is a parameter.

>>I want the record with the second instance of ‘4’ going to Table C.

Yes, but what defines the "second instance" ? Is it arbitrary ? Or based on...

Untested, but may be more efficient:

select  Distinct datepart(yyyy, start_date) as dmyear

from Mydatabase.adm.activitylog

order by datepart(yyyy, start_date) desc

[Edit] Tested with a...

Untested, but something like this. Join your table to 2 virtual tables, which get the required max date per person, and identify which year 14 record to updaet

Update YourTable

Set end_date...

>>I observed the second query returning results faster

In that case I suggest you send your table DDL and queries to Microsoft PSS, because the days when the order of conditions...

Are the data sources all SqlServer, or are any of them Jet 4.0 ?

http://support.microsoft.com/default.aspx?scid=kb;en-us;281517

So these tables are identical in structure and are essentially a horizontal partitioning scheme, with 1 table per month ?

Why not just build a UNION view across all the tables...

Is the primary key on the 3 columns clustered or non-clustered ?

Any other indexes on the table ? (Did you display the execution plan each time to verify what method...

Without the table DDL it's not clear what the best solution is.

Does the child table have a unique identifier where selecting the MIN() of it in a subquery would yield...

Do you have a column in the table that contains an inserted timestamp, or an increasing value like an Identity column ?

Try running sp_refreshview on the view.

Read BOL on topic DBCC DROPCLEANBUFFERS.

On the 1st test, SqlServer likely has significant disk IO to perform to bring the pages into memory. On 2nd and subsequent tests, the pages...

2 alternatives:

When they select 'ALL', does that essentially match every row based on a given column ? If yes, then selecting 'ALL' means you don't need any criteria on that...