Trying to Make combinations within a bracket in SSMS column
-
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?
-
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. -
duplicate posting, see original at:
- Chris Harshman wrote:
duplicate posting, see original at:
Nice collection ….Keep posting such things.
-
I want to read some competent answer too, just will wait here
- HardissonHard wrote:
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
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) -
Closing as duplicate
Viewing 7 posts - 1 through 7 (of 7 total)
The topic ‘Trying to Make combinations within a bracket in SSMS column’ is closed to new replies.