If the file you are trying to bring in is a text file (fixed field, CSV, Double-Quoted CSV, etc), you can use BCP or, perhaps, Bulk Insert which both operate...

If you aren't making any modifications, seems like the old DOS COPY command would work better and faster.

What is it that you are...

Angela,

Lookup "Expanding Hierarchies" in "Books Online"... has full explanation and an easily modifiable example script that could be changed to a stored procedure.  That's one way to do this.

Another way...

Here's a couple of other ways...

SELECT

   LEFT(SalesName,25) As Name

FROM

   CommERV

WHERE

   ProcessDate = '1/1/05'

   AND RevDate = '1/1/05'

   AND TIN = '2042416'

SELECT

   CAST(SalesName AS VARCHAR(25)) As Name

FROM

   CommERV

WHERE

   ProcessDate...

If you have a clustered index or a primary key on the table (and you absolutely should have a Primary Key on every table), the data will be displayed in...

Andrew,

You'll need to limit the outputs of the UDF's to make it fit your needs, but here's the whole ball of wax... explanation is in the comments.  Includes the test...

High praise from the resident MVP.  Thanks, Frank.

I would do as you said... add the extra column with the 2 character country code to the Country table .

The first 6 characters of date format 100 (mon dd yyyy hh:miAM (or PM)) almost have what you need except for the single blank space.  Here's another way to do...

Hector,

I'm on my way out, just now so I need to be brief but I'll be back.

The usual problem with "comma delimited" files is when an extra comma is added...

Hello Hector,

I don't think you want to use ISQL to do this.  BCP will not only determine errors, but any records that don't match the table definition can be automatically...

When you have 0% to start with and the task is large, an 80 or 90% solution would probably be pretty useful as a start.

There's some pretty good posts here that already work, but I thought I'd throw in my 2 cents... this is what I use and it will find "whatever" in all...

If the Recovery Mode is set to Simple, as you say it is, turn on the TRUNCATE LOG ON CHECKPOINT option and delete in smaller chunks.  You may have to...