InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 06:48:24 GMT20http://www.sqlservercentral.com/Forums/Topic1369730-338-1.aspx[quote][b]mubarak.a (10/8/2012)[/b][hr]Hi,I'm new in SQL Server, i want the working process of STUFF & ISNULL. How it works & how it concatenate the row level data into a single data? Please...[/quote]Look at: [url]http://johnnycoder.com/blog/2006/09/05/concatenate-multiple-rows-into-a-single-string/[/url]HTH,RobMon, 08 Oct 2012 06:15:03 GMTrobert.gerald.taylorhttp://www.sqlservercentral.com/Forums/Topic1369730-338-1.aspx[quote][b]mubarak.a (10/8/2012)[/b][hr]Hi,I'm new in SQL Server, i want the working process of STUFF & ISNULL. How it works & [b]how it concatenate the row level data into a single data[/b]? Please...Thanks in advanceRegards,Mohammed Mubarak.[/quote]Concatenation generally involves more than simply STUFF and ISNULL. Can you post an example of the type of query you are referring to?Mon, 08 Oct 2012 06:02:24 GMTChrisM@Workhttp://www.sqlservercentral.com/Forums/Topic1369730-338-1.aspx[quote][b]mubarak.a (10/8/2012)[/b][hr]Hi,I'm new in SQL Server, i want the working process of STUFF & ISNULL. How it works & how it concatenate the row level data into a single data? Please...Thanks in advanceRegards,Mohammed Mubarak.[/quote]Books Online is a good place to start - and post back with any specific questions you may have afterwards.[url=http://msdn.microsoft.com/en-us/library/ms188043%28v=sql.90%29.aspx]STUFF[/url][url=http://msdn.microsoft.com/en-us/library/ms184325%28v=sql.90%29.aspx]ISNULL[/url]Mon, 08 Oct 2012 05:53:31 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1369730-338-1.aspxHi,I'm new in SQL Server, i want the working process of STUFF & ISNULL. How it works & how it concatenate the row level data into a single data? Please...Thanks in advanceRegards,Mohammed Mubarak.Mon, 08 Oct 2012 05:38:48 GMTmubarak.a