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: 246993

  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

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• 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