It's much easier to understand the second code sample posted, however:

1. The figure of 12 for the max substring length is arbitrary but should be >= the max string...

Sure.

This statement:

SELECT number

FROM Numbers

WHERE ... SUBSTRING(@String, number, 1) = @Delimiter

means "select rows from the Numbers (tally) table only where Numbers.number is equal to the character position of a...

You're welcome Harsha. Don't ya just love a happy customer? 😀

Here's another slightly different version which is easier to test and accounts for leading and trailing commas:

[font="Courier New"]CREATE PROCEDURE proc_Function_Explode_New2

   (@Delimiter CHAR(1),

   @String TEXT)

AS

DECLARE @StringLength INT

SET @StringLength = DATALENGTH(@String)

CREATE TABLE...

Its not the solution..

There is the problem what i found after working on it more today.

I am not able to split my text field. Today I found that the substring...

Harsha Bhagat, if the proposed solution posted in your original thread fails to work for you, then why not post there, explaining...

harsha.bhagat1 (9/1/2008)

---

So now if I want the substring to work the way i want do you have an idea to solve this.. as this thing is eating my head now...

I...

Robert

SELECT CHARINDEX(@Delimiter, @String, @number)

will fail i.e. return 0, if @number exceeds 8000 characters.

Cheers

ChrisM

harsha.bhagat1 (9/1/2008)

---

Hi,

The article is excellent and working on it I also gone into the problems facing text datatype .

But when you say use the substring , for me its is...

Of course you can use a tally table with text values.

This is ugly because you can't use CHARINDEX() with text values and it assumes that the max length of a...

GOD (8/29/2008)

---

this is a better option... this works well for 3 columns... was developed by my friend.... good one...

Jus fill the values in the pivottable table and run de...

nairsanthu1977 (8/27/2008)

---

Dear All,

I have a master table called REQUEST. Each request may have been assigned to multiple employees. So I have another detail table where in there will...

Duplicate post, see http://www.sqlservercentral.com/Forums/Topic559341-338-1.aspx

Duplicate post, see http://www.sqlservercentral.com/Forums/Topic559341-338-1.aspx

Duplicate post, see http://www.sqlservercentral.com/Forums/Topic559341-338-1.aspx