July 15, 2020 at 5:06 pm
This is what the data looks like, I need to break the Column TID prefix as the first letter outside of the brackets needs to be combined with every letter inside the bracket. for example: A[CL] needs to broken down in 2 new rows as AC and AL.
Can someone please help me with this?
July 15, 2020 at 7:04 pm
I think this was answered in another post already, no?
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
July 15, 2020 at 8:15 pm
duplicate posting, see original at:
August 27, 2020 at 8:50 am
duplicate posting, see original at:
Nice collection ….Keep posting such things.
September 4, 2020 at 9:26 am
I want to read some competent answer too, just will wait here
September 4, 2020 at 2:24 pm
I want to read some competent answer too, just will wait here
Then go to the other post people have cited. 😉
Since your nondescript post strongly resembles a "test prelude" by spammers, be warned that we're watching and that spammers are dealt with swiftly.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 4, 2020 at 2:50 pm
Closing as duplicate
Viewing 7 posts - 1 through 6 (of 6 total)
The topic ‘Trying to Make combinations within a bracket in SSMS column’ is closed to new replies.