Y-e-e-e-o-o-ow!  Cursors, Ali?  You don't need cursors for this... James and Tomm are correct... import the whole file into a very wide staging table and then have a process for...

Guess I don't understand... Oleg's code seemed to work fine for all conditions according to what the OP wanted... here's the code again...

select

 replace(ltrim(replace(data,'0',' ')),' ','0')

from @Temp

That's cool... you should post the site in the Jobs forum with that info... you'd be surprised at how many bites you get.  You can even do it a couple...

Heh... I guess I'll never understand that...

Rainer, what say thee?  It's always an interesting topic... why is it that your users are allowed to create views without going through...

Yep, kinda figured that... was hoping you would post the actual record layouts...

Heh... kinda what I thought... some things just don't change.  Thanks Michael.

You still haven't said what the cursor is for, though

If it takes 4 minutes to open such a simple cursor, you still think cursors are good for something?   I did't get much from...

1.  It's a cursor (Seriously)

2.  It's XML (Pretty sure cursors and XML don't get along so...

Go to edit a post and then click on the delete button at the bottom...

By the way... these new columns should be "computed columns"... not real ones.  Computed columns can be indexed if they are deteminate and they're self updating...

Different slant on the month/year...

SELECT RIGHT(CONVERT(CHAR(10),GETDATE(),103),7)

Nope... not your fault, Surya... you had a problem, you described all the symptoms, and we all missed it.   We should be apologizing...

This is a "quadruple post", now, ALI... recommend you don't do this again...

Ali... this is the 3rd formum you've posted this same question on here at SQLServerCentral... you'll find that it makes folks pretty mad for a lot of reasons and I...