I apologize Sam. Its working perfectly fine.

I ran it for 460K records and it took ~5mins which is really not bad.

Thank You!

Jason - I wish but it was a great...

Thanks Sam.

It IS faster though its not returning the correct fullPath.. I am working on it.

I'll let you know how it goes

I just found out that the live server is SQL 2000 and so I can't use Recursive CTE :crying:

I have created this new script that would work on SQL Server...

This works like a charm.. updated 70k records in 24 sec.

Thanks Jason 🙂

Jason this looks right. But how to update FullPath column using Recursive CTE? I have to update all the rows of the table for FullPath column. Actually the right way...

I just added the Sample data..

Do you want the code for Triggers?

The triggers only fire on Update of hirNodeParent column and Title column and I am only updating the...

Thanks.

I'll keep that in mind 🙂

Shark,

1 day wont make any difference if the month is the same. Most of our reports are generated on monthly basis so now that I am sure the date is...

And Yes the difference is always of 1 day

Shark,

You are absolutely right. Some Values are converted correctly and some aren't.

Hi Shark,

Declare @OrderDate varchar(100)

--Original DateTime from Excel

set @OrderDate = '40441.50551'

select CONVERT([varchar](10), dateadd(day,-2,convert(decimal,@orderdate)),(101))

select CONVERT([varchar](10), dateadd(day,-2,convert(decimal,substring(@orderdate,1,5))),(101))

Results

09/21/2010 --Incorrect

09/20/2010 ...

What i actually need is this -> January 19^th, 2008

like a superscript. Actually i'm writting data to a Word 2007 .docx template so all the work has to be...

What i actually need is this -> January 19^th, 2008

like a superscript. Actually i'm writting data to a Word 2007 .docx template so all the work has to be...

That much I've done but i don't know how to add suffix.

Hi Jeff,

Thanks, Your code works great.

And I'll remember what you said about not storing formatted numbers.

I just needed to retrieve data from database and format it in the select...