Concatenate two rows into one row being returned

• GBeezy

  SSCarpal Tunnel

  Points: 4717

  More actions

  March 21, 2022 at 5:26 pm

  #4003596

  I have a temp table that returns the following:

  Month     Year

  09             2021

  12              2021

   

  And, I was the following returned: 09-12-2021.

   

  Is this possible?

• wburke 85918

  SSChasing Mays

  Points: 619

  More actions

  March 21, 2022 at 5:35 pm

  #4003599

  Are you sure it sounds like you want "9-12 2021" as in September-December 2021.

  Select MIN(Month), '-',MAX(Month), Year

  or

  SELECT Select MIN(Month), '-',MAX(Month), '-' Year

  • This reply was modified 2 years, 1 month ago by  wburke 85918.

• April 4, 2022 at 5:17 am

  This was removed by the editor as SPAM

• April 4, 2022 at 5:17 am

  This was removed by the editor as SPAM

• jschmidt 17654

  SSCommitted

  Points: 1610

  More actions

  April 4, 2022 at 4:48 pm

  #4010610

  I'd try a Lead or Lag with a partition by Year if you are on SQL 2012 or newer.

• April 25, 2022 at 8:54 am

  This was removed by the editor as SPAM