But...

<a href="/back_to_school"> this string keep changing

for 1 column it is 'back_to_School' and for another it is 'doctos_report' etc

Only constant that chage is

<a href="/xxxxxxxxxxxx">xxxxxxxxxxxx</a>

where xxxxxxxxxxxx keeps changing from...

There are 2 tables with millions of records. On table 1 a clustered index is created on varchar datatype column which holds SSN. There are no duplicate values

On...

Hi,

Sorry about that.

I will not repeat it again.

I did not realize I posted on Sql Server 2008. Hence posted in Sql Server 2005 again.

As I was getting response on...

Yes . It worked.

Thankyou Thankyou for the sweet and smile script.

Hi,

Thankyou for the beautiful(easy to understand) script.

But this scirpt will fail to create the ParentID when ID_Note has something like this "1.1.1.4.2.10", " 1.1.1.4.2.11"

How should I handle this scenario

Thankyou...

So I have to write a script for filling ID_parent field, for ID_Current it is just the next value….

For ID_Parent,

I need to take id_note value trim last two...

There is no crypted logic here

I have to generate parent_ID based on the the value we have in ID_Node (something like Tree)

For example :

The 1st value for ID_Node is...

Hi,

Added the tables and their data to understand the issue better.

Thankyou for you support

Thanks for your suggestions.

Thanks a lot. These articles are really helpful.

Note: It is many rows per state and one row per bracket.

Thanks,

Naru.

Thanks for your reply.

Let us think that brackets 0-50, 50-100 are not going to change. Your suggested design is...

StateName ...

SELECT * from sys.procedures where modify_date >'12/20/2007'