There's gotta be a thousand posts on this web site for "crosstab" and "transpose" and "pivot".  Do a search on it and I'm sure you'll find one that fits.  Also,...

Thanks for the feedback, Therion... it means a lot to us that someone is actually looking at the answers.  Appreciate it much!

Looks more like homework to me...

Putting the Recovery Mode to Simple sets the 'trunc. log on chkpt.' to true automatically.  Your problem is the log... your Insert/Select is still logged despite the SIMPLE setting you...

p.p.s.  Why the hell are you using DTS for such a simple BULK INSERT task, anyway... you like "slow" or something

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...