Concat resultset

• revozex

  Old Hand

  Points: 326

  More actions

  February 6, 2012 at 6:30 am

  #391481

  Hi Mates,

  I have a query which produces result set containing 2 or more rows as follows:

  Query:

  SELECT [BudgetCode] FROM [BudgetCode], [Employee] WHERE Employee.EmployeeId = [BudgetCode].[EmpId] AND [Employee].[EmployeeCode] = 'M-1-490'

  Resultset:

  BudgetCode

  LM12340

  LM13748

  I wish to present result set as

  BudgetCode

  LM12340/LM13748

  Can anyone help it out?

• Cadavre

  SSC-Forever

  Points: 41690

  More actions

  February 6, 2012 at 6:36 am

  #1443074

  SELECT STUFF(CAST((SELECT '/' + [BudgetCode]

  FROM [BudgetCode], [Employee]

  WHERE Employee.EmployeeId = [BudgetCode].[EmpId] AND [Employee].[EmployeeCode] = 'M-1-490'

  FOR XML PATH(''),TYPE) AS VARCHAR(MAX)),1,1,'') AS [BudgetCode]

  ---

  Forever trying to learn
  My blog - http://www.cadavre.co.uk/
  For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
  For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  ---

• revozex

  Old Hand

  Points: 326

  More actions

  February 6, 2012 at 7:05 am

  #1443100

  Thankyou Cadavre 🙂 It worked!