I hope your comment was made as a joke, for it was not ....

Without prior knowledge of the QOD author I surmised it was you...

Now a general question for yourself .... in your experiences, around the world, what would you say are the...

Now this is NOT a complete solution to your requirements, but a step by step snippet of code, which you can expand upon for all your fields.

CREATE TABLE #T(Weight INT,...

In MHO there are two types of criticism, constructive and its opposite, destructive and depending upon the circumstances one must select which to use.

In the case of poorly written code,...

Nice question. It is good to be reminded of the basics.

1, What language is your app written in?

In any case does your app count each line 0f the file,...

SQL Kiwi (11/10/2011)

---

I can't believe I spent as much time as I did on this question. Let me share...

.

. Portions of the original post by SQL Kiwi ...

Ninja's_RGR'us (11/10/2011)

--------------------------------------------------------------------------------

We're waiting on an OR & date. He's on top of the list. He needs an open heart surgery to fix 5 different problems. That's 10 hours on the...

Now that is another QOD to which...

I have used

MCTS Exam 70-4d33

Microsoft SQL 2008 -

Database Development

Library of Congress Control Number 2009924965

Purchased my copy from Amazon.com

Good lessons - CD with sample code, questions, etc.

Try adding a line feed CHAR(10) immediatel before or after the carriage return

Koen Verbeeck (11/8/2011)

---

SQLRNNR (11/8/2011)

---

Koen Verbeeck (11/8/2011)

---

I ran it in SQL Server 2008R2, and I got the severe error.

The plot thickens......

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0','Text;Database=D:\MSSQL\;HDR=Yes;', 'SELECT * FROM Test.txt')

SELECT * FROM Keywords

True this is for iimporting data ... but use HDR=No; It might be worth a quick test

Thank you for replying ... Remember when posting detail you do NOT want to post data that is confidential, so if that is the case you may have to do...

Many who can answer your question do not like opening attachments to be sure that a bug or malicious code is not included. To help you get an answer,...