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

Heh... I'd like to know why a "user" is allowed to create anything in a database, especially views.   Improperly written views can bog...

Ummm... could you use a trigger in such a case?  Or would the trigger hang until the job was complete?  Asking 'cause I don't know much about 2k5... stuck in...

Duplicate post...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=383148

Ali,

When you say "flat file", do you mean all of the rows have a "fixed field length"?