Thanks for the reply.

The transaction is necessary. A possible sequence of calls is

Begin Tran

Call UpdateAccountTransferFrom and return rowversion

Call UpdateAccountTransferTo and return rowversion

...

End Tran

RowVersions now obsolete.

I use UpdateAccountTransferFrom/To for illustration....

Thank you.

Your suggestion works - but the time sucks. To perform the join SQL Server retrieves ALL of a very large table from the client and (I am told)...

Thanks All,

Lots of good ideas here.

I was hoping that there might be some relevant OPTION variant that I had missed.

I figure one way of doing this is to write a comma delimited file (or perhaps...

Kathi,

This is a big improvement over a cursor.

Although User/ActionId are relatively sparse and there are some missing numbers, this solution makes at most 256 updates irrespective of the number of...

In general Schema modification thru Access Project is dead.

Good luck waiting for the patch. From what I hear MS has abandonned Access Projects.

The reasons offered being managed code and...

Simple insert your parameters into the query

Select @Beginning as BeginningDate,@End_Date as EndDate, .. then the rest of your SQL.

I've replaced the fetch cursor with the following key chaining approach:

Set @OldUniqueKey = 0

while 1=1

Select Top 1 @UniqueKey=UniqueKey,... from Movements

Where UniqueKey >...

Nice trick - I'll remember it. I don't think that it will help me in this case as a batch could contain the same item multiple times which would necessitate...

I am using T-SQL in a stored procedure. The interference comes from an Access user doing Access user sort of things.

Aside:

I would love a non-cursor solution. The problem is this:

1....

Try:

SELECT TOP 100 PERCENT

object,

MIN(CASE WHEN itemid = 1 THEN item END) AS [1],

MIN(CASE WHEN itemid = 2 THEN item END) AS [2],...