STUFF & ISNULL

• mubarak.a

  SSC Veteran

  Points: 294

  More actions

  October 8, 2012 at 5:38 am

  #393332

  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 advance

  Regards,

  Mohammed Mubarak.

• Phil Parkin

  SSC Guru

  Points: 246686

  More actions

  October 8, 2012 at 5:53 am

  #1546660

  mubarak.a (10/8/2012)

  ---

  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 advance

  Regards,

  Mohammed Mubarak.

  Books Online is a good place to start - and post back with any specific questions you may have afterwards.

  STUFF

  ISNULL

  If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

• ChrisM@Work

  SSC Guru

  Points: 186127

  More actions

  October 8, 2012 at 6:02 am

  #1546663

  mubarak.a (10/8/2012)

  ---

  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 advance

  Regards,

  Mohammed Mubarak.

  Concatenation generally involves more than simply STUFF and ISNULL. Can you post an example of the type of query you are referring to?

  ^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

  For fast, accurate and documented assistance in answering your questions, please read this article.
  Understanding and using APPLY, (I) and (II) Paul White
  Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

• robert.gerald.taylor

  SSChampion

  Points: 13133

  More actions

  October 8, 2012 at 6:15 am

  #1546677

  mubarak.a (10/8/2012)

  ---

  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...

  Look at: http://johnnycoder.com/blog/2006/09/05/concatenate-multiple-rows-into-a-single-string/

  HTH,

  Rob