GrassHopper,

Here is a version of my query with columns added. Bit of a rush job so may need to check it. It still doesn't do the schemas though. Oh, and...

An oversight.

Yours is probably the more complete solution from a generic perspective, including columns etc. My approach was based on the OP's code...

There are probably several ways of doing this. One approach is something like this:

DECLARE @sql NVARCHAR(MAX) = N'';

;with tabsWithId as (select t.Name
     ,...

I may be missing the point but...

I notice that your addition to the WHERE clause just targets the left table. You are LEFT OUTER JOINing to the right table, but...

It would probably have been helpful to show the current select query. However, it feels like the LEAD function may help. An example of usage is:

SELECT *
,...

Do you have an example of the output you are expecting to generate? It feels like one or two CTEs which are then joined may be the way, but it...

Thank you for the reply. This was the sort of info I was hoping for.

I will likely pursue this route in the next appropriate project. I was wary about wading...

Are you referring to SPID? If so, you could just exclude the current SPID (@@SPID)...?

If you just want to know if there are any such records it is usually better to use "exists" rather than making SQL Server provide a full count

            
November 18, 2019 at 10:55 am
            
#3698462

            
            
                                                
        

Minor tweak, but if it's SQL Server you could possibly replace

UPDATE account SET active_yn =0 WHERE account_code='4c'
SELECT 'AFTER' 'AFTER', * FROM dbo.account WHERE account_code='4c'

with

UPDATE...

Assuming the query is the same in both instances I would probably be looking at the connection from the app to SQL Server. You have given no clue as to...

As pedantic as this is.....

"I can see only one way to do this"

  IF len  (ltrim(@datetimevar)) <= 8 and charindex(':',@datetimevar) > 0

I...

Yes, my bad as I failed to read the original question properly. I assumed wrongly that CustId was a PK.

I'll return to my cave.

Not sure if I am missing something here, but why can't the following be used?

delete Customers

where CustID NOT in (

...