its very helpful. Thank u:)

I have a lot of those in my snippet manager by Red Gate. Say, I type dvCSV... and up comes this exact snippet of code right in the SSMS. Are you sure you don't need to cast xml as varchar(max) before stuffing empty string instead of the first character? Just saying.

No need to cast as far as I know - thanks for the comment!

Well then, it's even simpler than I thought! Keep up the good work, Mr. Beer Man. :)

Regarding your CAST comment - you're absolutely right. If the overall string length gets too large you run into it being truncated. I'll update the post to reflect this, and thanks for jogging my memory (came across this problem a while ago!)

very help full tip, thanks!

How to add this to a report in SCCM reporting? So the report returns multiple lines for each PC (one for each NIC). I get a lot of syntax error, while trying to implement the fields from SQL views in your code.

I want the same thing but with some changes like Model 1, Model 2 , Model 3, Model 4, Model 5 , Model 6 , Model 7, Model 8, Model 9 , Model 10 + 5 more when there are 15 models . Can any one help ?

Thank you very much.Its helps me.God bless you.

What if my ModelThisFits from 3rd table?

Do you have an example? Not sure what you mean.

What if my ModelThisFits from either M.ProductId or P.ProductId?

Perfect !

Thanks for explaining it in a simple way....

Very useful, thanks :-D

Thanks for example, very helpful !