i just want the after trigger to record data in one record instead of two etc.

ID | OLDVALUE | NEWVALUE

It is showing the following 2...

Thanks Joe, your trigger worked perfectly also but i can't seem to get it down to one record. I've researched and found that an update trigger is both an insert...

I tried the following for the trigger but a strange thing seems to be happening

UPDATE dbo.InfoTable SET LastUpdatedBy = SUSER_SNAME(), TimeRecorded = GETDATE()
WHERE ID_COUNT_ IN (SELECT ID_COUNT_...

Thanks Joe. Does that mean it will complete the trigger and accept no data edits on the table until the trigger completes ?

Would that possibly cause an issue...

what does With SCHEMABINDING mean ?

thanks guys. i will try soon and let you know 

A third party app can make multiple record updates to the table and that is where i am seeing...

thank you

How do i check for recursive triggers enabled ? Is that a setting or check if other triggers exist on the database etc.

No problem, thank you

One Table is an AuditTable so i'm placing the old values and new values just for comparison in the AuditTable when records are changed
Then...

Thanks SSC

If i take out the Select Top 1, will this query handle multiple rows inserted or do i need to change my query to handle multiple rows...

what about string split? came across this here and working on test 2017 SQL Server

https://blog.sqlauthority.com/2018/05/04/sql-server-split-comma-separated-value-string-in-a-column-using-string_split/

How do i select values from one column with string split...

thanks, i'm  a novice, how do i use it

Got the following to work Phil with help from another forum. Thought i'd post it here to help others

WITH CTE AS (SELECT EmpID, TimeDuration

FROM dbo.D_Modules

UNION ALL

SELECT EmpID, TimeDuration

FROM dbo.D_Activities)

SELECT TOP...

Got the following query to run but it is not applying the case argument. Any ideas appreciated ?

WITH CTE AS (SELECT EmpID, TimeDuration

...

Sorry Phil. I don't follow. This is way beyond my ability

Do you mean build the case on top of the query? I tried the following but resulted in error

SELECT TOP (100) PERCENT EmpID, CASE WHEN TimeDuration...