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?
-
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".
"Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Closing as duplicate
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
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.