Actually, there is!  It comes in the form of the PARSENAME command which was specifically developed to break apart the parts SQL object names "at the dots".  Since your example...

Thought AH did a pretty good job!

In that case, Bulk Insert has a MAX ERRORS setting that works just like the BCP -m parameter.  Again, check BOL under Bulk Insert.

No execution plan is formed for Dynamic SQL until Runtime regardless of method of execution.

Not sure but I think it may be the way that Crystal is using the view... I believe that it creates a different instance of the view for each instance that...

Kokyan gave a good example of "Dynamic SQL"... just wanted to remind everyone that dynamic SQL can be quite a bit slower than "Static SQL" because it does not pre-form...

It's a forum, not on-line help...

Anyway, use the -m parameter followed by the number of errors you wish to allow.  Lookup BCP,Overview in...

1. You need to assign a "table alias" to the SELECT in the FROM clause.

2. You need to use that table alias on all column names to the right of...

Basically, @@Error only lasts for one successful line of code so by the time you get to the "SET @out_param = @@Error" chunk of code, @@Error has been reset to...

Add the "-n" parameter to your command line to suppress both the prompts and the line numbering.

Recommend you use OSQL instead.

Not sure if it uses the 'Sum of Product - Mod 10' method you were talking about but...

Have you tried the CHECKSUM function in SQL?  It's in "Books on line".

--Jeff...

Richard,

It's a bug and it's in BCP as well as bulk insert.  The only time the "First Row" option works correctly is when the rows to be ignored, the first...

The "-c" parameter, as you are probably aware, uses the CHAR format.  What you might not know is that it adds the "newline" character as well.  Hex "0D" is a...

Lookup "hierarchical information" in Books on Line for an example.  Has a bug in it but shouldn't be hard for you to find.

--Jeff Moden

Kind'a what I thought... Thanks for the quick reply, Gary!