Any suggestion is appreciated.

Thank you
Best,
Majdoleen

Thank you all, I do agree with you that it is a bad idea, but unfortunitly, this is the only way which I found that may resolve my main...

Sorry for the confusion, Sgmunson, you are right I have to be a lot more specific, your query is working fine, but I want...

Thank you so much for your reply, I would appreciate if you try to send me a generic code depends on the name of my fields. I tried...

Adding  extra `)` at the end of the line before the FROM section hadn't resolve my issue, I think in my opinion it is due to Null values in...

Thank you Thomas, But I think my code needs some enhancement, since I have a null values in the field "SOURCEWOID", do you have any ideas how...

I tried to write this code but seems not to work with me, and displayed the error attached.
CREATE TRIGGER dbo.My_TR_WORKORDER
ON dbo.WORKORDER
AFTER INSERT, UPDATE, DELETE
AS
SET NOCOUNT...

Any updates??

Thanks
Majdoleen

Thank you Joe Torre, but what sgmunson mentioned is right.I want to concatenate all the...