Trying to Make combinations in SQL

• riddhi10

  SSC Veteran

  Points: 202

  More actions

  July 15, 2020 at 3:27 pm

  #3770246

  I have a column in SSMS where I am looking to make different combinations. For example I have a column for names such as A[123] where I need to make combinations such as A1, A2 & A3.

  can any one help me with this please?

• Jeff Moden

  SSC Guru

  Points: 1004619

  More actions

  July 16, 2020 at 6:39 am

  #3770461

  This is a triplicated post and multiple solutions have been provided.  Please... no posts here.  Instead, see the following post where all the other answers are...

  https://www.sqlservercentral.com/forums/topic/trying-to-make-combinations-within-a-bracket-in-ssms-column

   

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)