Thank you very much Ten! 

Can you or anyone help the codes I have here?  I'm trying to pull the total of files received for each databases. I have...

Thank you very much All for your efforts.

I think I got it now. By replaceing ® sign where Char(10) is, The ® sign is used as a trick for...

Thank you so much. You are very good. You reminded me about this function I used before. Iteeaked it a bit to nvarchar(max) because my xml file is really huge....

Oh ok. That's fine. I think I understand now how SQL server has to know which level to pull info. Thank you so much. 🙂

Thank you very much. It works great. I thought I had to put in nodes at thr From clause but rather in the select clause. In this way, We have...

Thank you ScottPletcher! It works perfectly. I think I should have added the UPDATE in the line of "AFTER INSERT, UPDATE" . I didn't know I can do add more...

Thank you very much Luis! I figured it out now. FOR XML PATH and STUFF to concatenate the multiple rows into a single row does do the trick. You're the...

OK. Thank you Luis! I really do need it. I'll figure it out.

Thank you very much for your effort Luis! I got it now!! 🙂 Cheers!

Thank you Luis! But, We only need to update two rows where AttachLevel is zero. Not every row. Sorry if I didn't make it clear enough. Thanks!