Lynn Pettis (5/28/2009)

---

Okay! Any one in Germany near Frankfurt? Maybe has a teen age (around 18 year old) son or daughter (preferably)?

And yes I am serious. I...

Paul White (5/27/2009)

---

Right then.

Given the wealth of knowledge and talent around these parts, who's up for writing the perfect collaborative-effort book on indexing?

We could all get fabulously rich!!!...

Paul White (5/27/2009)

---

arun.sas (5/26/2009)

---

Never assume the VAT means “Value...

Blimey, small world...I was born in Wroughton in the old RAF hospital - and shoot every saturday now at Roves Farm, a couple...

GilaMonster (5/5/2009)

---

Why would I ever trace a gorgeous African summer for that damp, slightly warm couple months that they call summer in the UK?

(before anyone gets offended, I'm originally from...

Derek Dongray (5/5/2009)

---

Some time ago, the BBC Radio 2 lunchtime show hosted by Jeremy Vine had a phone in to find the best opening lines of all time.

And the winner...

Jan Van der Eecken (4/29/2009)

---

David Webb (4/29/2009)

---

Yes. I saw it 5 times during the next two weeks and saw some new detail I had missed on the times before....

GilaMonster (4/29/2009)

---

tosscrosby (4/29/2009)

---

Lynn Pettis (4/28/2009)

---

You know, I can think of some one else that, IMHO, ranks right there with our favorite White House window washer, and here is his latest...

peggyah (4/22/2009)

---

I have a similar problem where I have records of individuals that are being tracked as they move through an area. I only what the see the last...

Please can you supply a source table create script with inserts for a few rows? If you're unsure about how to do this, read the link in my sig.

Cheers

ChrisM

Interesting - the primary key consists of [CostWorkOrder] plus another two columns, but [CostWorkOrder] is also defined separately as a unique key (the DML for this isn't in your script)....

The last four rows in your list appear to be 3 columns shorter than the previous rows - is this real or an artifact?

You could identify which row(s) are...

There are only 17 columns in the sample you posted earlier.

In your shoes, I'd create a new file containing the first row from your flat file, copied down say...

Jeff Moden's excellent article here[/url] describing how to do this is currently being rewritten to accommodate changes between SQL2k and SQL2k5. However, the SQL2k code, which is what you're interested...

How many rows and columns in the flat file?