Yeah... me too... sorry you had to wait 4 years for the answer...

I agree... NOT EXISTS implies a correlated sub-query which is another form of RBAR (pronounced "ree-bar" and is a "Modenism" for "Row By Agonizing Row").

Now, the interesting part is that...

Another way... with right justification to boot...

 SELECT STR(COUNT(DateCol)/110.0*100.0,8,1)+'%'

   FROM @Table

P.S.  It won't blow up after 6,759,999... but it will start the sequence over, so you may want to put a constraint on the IDENTITY column to be >=0 and...

Ummm beat me to it... well, almost... please send beer, I already have enough pretzels...

--===== If the demo table exists, drop it

     IF OBJECT_ID('TempDB..#yourtable') IS NOT NULL

        DROP...

TNT,

Just for grins, can you post the "header file" and a row or 2 of data (making sure, of course, there are no SSN's, account numbers, etc in the file)? ...

Sure, Bakr... but I need a wee bit more information...

1. Did you end up with any continuation lines?
2. Can you use xp_CmdShell?
3. Can you post the DDL for the table (be sure to indicate...

Perfectly clear, thank you...

 DECLARE @TestData TABLE (StringValue VARCHAR(20))

 INSERT INTO @TestData

 SELECT '0000022211' UNION ALL

 SELECT '0000022243' UNION ALL

 SELECT '0000072211' UNION ALL

 SELECT '0000102221' UNION ALL

 SELECT 'AB00011'    UNION ALL

 SELECT 'CD000111'

 SELECT...

What did you find out about memory?  Do you have an app that someone recently made a change to that has memory leaks?

Also, since it occurs so regularly, have you...

Heh...

Dinesh... take a look at the following for a complete explanation as to why ISNUMERIC should never be treated as ISALLDIGITS... and, it's not a fault... it's a feature...

Please folks... make sure you really, really know what you're doing... if you set 'trunc. log on chkpt.' to true, you have a little surprise coming...  try this...

Set the recovery...

Do you mean like this when you say to "ignore if is character data"???

DECLARE @t TABLE( sort varchar(20))

INSERT INTO @t

SELECT '1dd' UNION ALL

SELECT '1x4' UNION...

Sree,

Rather than us guess, do you have some samples of the data before and after the sort you'd like?

It's been "summarized" into the "Recovery Mode".  I believe the "Simple" recovery mode enables it (and SELECT INTO/Bulk Copy, etc).

Personally, I'd hunt down and shoot the bugger that put a Text column in the database in SQL Server 2000.

Also, why the heck...