Trying to Make combinations in SQL

Question

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?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004289 More actions · Answer 1

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)