Great jobs guys, and the execution time is excellent, it reduced processing time from 3 hr45min to 2 mins. Thank you for all your input!:-):-D

thanks guys, sorry for replying so late, i am trying them out today

🙂

thanks guys

nvarchar(4000) is set to the column, so I assume that no string is longer than 4000.:-)

yes, I can create or use stored procedures on the server.

:crazy:but i have not .Net programming experience

yes, i believe so

to decode 9632 records into 32,000+, it took 9 hours and 45 minutes using kumar20's method.

I created a loop to process 1000 Records at a time.

any comments or suggestions please?

SET...

There will not be any comma in the strings, but the strings are wrapped in double quotes

Jeff Moden (2/23/2011)

---

JJH82 (2/22/2011)

---

hi kumar20, the script cannot process some name characters, e.g. '&',...

hi kumar20, the script cannot process some name characters, e.g. '&', '<'

',2 Column_Names "FIELD_NAME" "READ_FLG" ,2 Old_Column_Values "Rural & Remote" "N" ,2 New_Column_Values "" ""'

'+2 Column_Names "ATTRIB_VALUE" "SCORE" +2 New_Column_Values...

yes, it does

, 8 Field_Name "1" "2" "3" "4" "5" "6" "7" "8"

thank you in advance

I appologise for the troubles I caused.

Here is a detailed structure of the source data:

1. the length of each row of string is not fixed

2. the data contained in the...

thanks kumar20, you code is working, However, I forgot to mention the fact that new value and old value can contain multiple words.

e.g. "new value" "Old value"

I am modifying...

a table called CLOB contains

ROW_ID (pk)

PARSE_CLOB (where the strings sit)

--=============================================================================

-- Setup

--=============================================================================

USE TestDB --DB that everyone has where...