;WITH CTE AS
(
    SELECT c.Id CustomerId, c.CustomerName, b.BalanceDate MaxDate, b.Balance, 'Bond' AccountType
      FROM [dbo].[Customer] c
    ...

• This reply was modified 3 years, 11 months ago by Jonathan AC Roberts. Reason: added view

Did you get an error message?

Has table tbl_probate_case got a column named case_submitted_date in the environment you are getting the error?

Each row contains something like 400 different columns / measures. There are some measures that are strings so each row has quite a large size.

The problem is! The DELETE...

There is a serious problem with the "equivalent" code you wrote though.  It's not "equivalent" in the results for the last 3 tests.  The table code comes...

There is a serious problem with the "equivalent" code you wrote though.  It's not "equivalent" in the results for the last 3 tests.  The table code comes up a...

Just change the order of comparison in the datediff for overlap to change the sign:

sum(CASE WHEN datediff(mi,t1.travel_end,t2.travel_start) <0 
    THEN datediff(mi,t2.travel_start,t1.travel_end) ELSE NULL 
END)...

Does it insert the data into the table variable in the correct order? You can tell if you query the table and look at the Id value.

So it produces the correct result.

To get it into 2 separate column just use the CASE statement I provided earlier.

Then just remove the other columns from the query you do...

that doesn't seem to give the total minutes of gaps and/or overlaps though? It just shows the 2 rows of data that may have an issue.

sql2000 does support TOP,...

Have you tried the options: optimize for unknown and recompile?

That is not really consumable data as I don't have all your tables that make up the query.

You could add an identity column to the temporary table then insert values...

not an option i'm afraid. this is what i have to work with.

i have done what you suggest though and used a...

I can't see how your SQL will work with all those right brackets?

Have you thought...