Any suggestions!

Thanks it works for me

'1010' is the input i need to split the input based on the startid, endid

startid, endid

1,1

2,1

3,1

4,2

6,3

so i need something like

1,0,1,0,11,123,........

need to split the string and insert into the table.

What you are trying to do will obviously takes time since you have used loop statement which means it will consume more time.

can you give some sample records at-least 5...

After Changing to Varchar(max) i am able to insert the data Thanks!

Hey thanks it works for me

but i am unable to insert more data since @sql is beyond varchar(max) since i am having table with column 122 i am unable to...

I am not doing any report kind of stuff , after getting the string i need to split those string then i need to insert to corresponding columns and do...

Any suggestions how can we optimize the query.

I have already created dynamic Pivot table in my 3rd post

http://www.sqlservercentral.com/Forums/Topic1374200-391-1.aspx

but the thing is it is consuming more time so i am looking for a alternate method.

Thanks!

Column is fixed but i may not...

ChrisM as i have said i am having some business logic's on...

NO This is not a report one i need to join some tables and...

The string splitting would ideally be in the stored procedure, so you would have parameters @str and @pos for the stored procedure.

Where do @str and @pos come from?

What will you...

create procedure @str varchar(1000),@param int

as

begin

.

.

i am having values in splitter table so there is no need of @pos here we can directly take the value from splitter...

We know all of this already. What can you tell us about

1. The process which generates these two strings - where do they come from?

2. How the data is consumed,...