Recent content by slhuber

I have a table of roughly 11,000 rows. A data access page with 3 levels of grouping/headers uses this table allowing users to navigate through the grouping levels to drill down into their detail data. There are no filters used - all data should be available. But what I've found is there are...

The tables are in the order they need to be before the update. So, I don't think that's it. I haven't seen this take more than two passes.... yet! But if the tables get larger, I'm wondering if it might eventually require more passes.

How can I ensure that they are being updated in a particular order with just a basic UPDATE statement?

Basically, each row is being updated with the company and date from the row before it, with a few exceptions. So, yes, the update is dependent on other rows to be updated. However, about 90% of the rows are updating successfully in this manner. Its just a few random ones (not the first, not...

I am running the following UPDATE statement on a table with about 1000 rows, using a self join: UPDATE [Tax Report Co Date] INNER JOIN [Tax Report Co Date] AS [Tax Report Co Date_1] ON [Tax Report Co Date].ID = [Tax Report Co Date_1].[ID+1] SET [Tax Report Co Date].Co = [tax report co...