Thanks Luis it worked.

there will be leading 0 like this way 0930 or 0700

I got answer. 

IF OBJECT_ID('tempdb..#TestData', 'U') IS NOT NULL
DROP TABLE #TestData;

CREATE TABLE #TestData (
String VARCHAR(20) NOT NULL
);

Thanks Jason. It worked now the way I want. Much Appreciated.

Jason if data is like this way (AS)(RT) output is coming as RT first and AS second. I want AS as first column

Max column is 4 but that data can have like this so what is best way to do

(DDD)(LL)(GGGG)(HH)
(FF)(GG)
(GG)
(GG)(HH)(LL)

output wants as
Col1    ...

Thanks Jason It worked.

It can have 3 character in that data too like that way (SS)(DDD)(GG) is there deliminator function in SQL

4 column max. it can be like that way (DD)(FFF)(GG)(HH) Field can have any character in ()

Thanks for the performance thing if i put into temp table and then join to that table it should be good on performance wise.

Thanks everyone input i was able to do from creating function

CREATE FUNCTION SplitString

(

@Input NVARCHAR(MAX),

@Character...

Yes i am trying to use IN Operation with client id as list. '2,3,4' so how you can do that without creating temp table. If i put 'ALL' it...

Thanks everyone. It works there is data issue i found there is single quto in between. I appreciate everybody help. I like about removing cursor and putting proper concatenation.

Thanks but i still have issue after 43667 char.

It work when i have 10 record in my KLA_Steps there are 1400 records there where it get fail. I think it is length giving problem but i have declare...