I would disagree with the normal way as using DelimitedSplit8K - if the goal is to split out to individual columns, using that utility would require a secondary pivot/cross-tab...

Well - you can avoid this issue using a slightly different approach.  I would create an iTVF to split the elements and then cross apply to that function.

            
October 4, 2021 at 6:20 pm
            
#3936368

            
            
                                                
        

I...

"It Depends".  I've found that a whole lot of folks end up writing code...

"It Depends".  I've found that a whole lot of folks end up writing code that causes...

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

• This reply was modified 4 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,...