In the old style syntax, a cross join was denoted by separating the tables to...

I'm sure it is. You'll either have to give db_owner access or speak to the vendor.

John

Thanks for posting back with the solution.

Please do not use the NOLOCK hint unless you completely understand the potential consequences. If in doubt, leave it out.

John

It's probably the application checking that you're a member of the db_owner role before you make the changes. If it allows you to proceed despite the fact you're not...

To generalise, if you have n tables Table1, Table2, ... , Tablen where for each value of k Tablek has k rows populated with values 1,2,...,k:

The COUNT is n!

...

Are the exclamation marks in the explanation an expression of surprise, or are they supposed to represent factorials?

John

Client? Why is the client interested in indexes? All he needs is a database that performs according to his expectations (or according to SLAs). How you, as...

You should find all the information you need in the restorehistory table in msdb.

John

Dominic

Here's another way of doing it. It avoids the correlated subquery in David's solution and so it may perform better. You'll want to test.

John

-- Data

WITH MyCTE(ClaimKey ,ARevDate ,ARowNum,CauseCode)...

I know. The full backup is in case shrinking the logs causes any problem that you might want to...

It's OK to shrink files if the reason they've grown isn't likely to be repeated. This is indeed the case in your situation - somebody set the database to...

This works for your sample data.

-- Union both tables together

WITH AllItems (ItemCode, FrgnName, UpdateDate) AS (

SELECT ItemCode, FrgnName, UpdateDate

FROM AITM

UNION ALL

SELECT ItemCode, FrgnName, UpdateDate

FROM OITM

)

-- Number the rows for each...

I'd wager that the trigger is your problem here. You've got functions within functions in it. You ought to try rewriting those functions as a very minimum. ...

Here's one way of doing it. It may not be the most efficient way, so you'll want to test for performance if you're going to use it in production.

SELECT...

Perhaps you're getting a page split? This can happen if you update a column with a variable length data type. How many indexes are there on your table?

John