Awesome!

Hi Jeff, the DBA does not allow me the permission to create/use tally function. Can you provide a solution without using it please?

I am denied the permission to create the function here

Hey Steve, I do not have fnTally as a function in my version of SSMS, My SQL Server is 110 compatible as is version 17

Also Brian, can we think about breaking this string down into various columns such as A[bcd] will be broken down to A,[,b,c,d,].... and then we cross apply A with all...

Can we do anything with String Split function Phil?

Can we do anything with String Split function?

What application would you suggest using for this, If i were to run row operations on the application side?

This what the column I am talking about looks like. There are thousands of such column and I need to break them down into multiple rows with...

• This reply was modified 4 years, 4 months ago by  riddhi10.

Hi Brian, thank you for your response above.

I guess the Header thing will not work here as my data goes something like this :

Column 1

A[kfg]

B[lr]

Cf

D[3r]

Out put required should have, the...