Also from MSDN under NVARCHAR at: http://msdn.microsoft.com/en-us/library/ms186939(SQL.90).aspx

--SJT--

By the way,...

I guess your issue is with SQL Mail?

Technically yes - but practically, none of these are enabled, so the end result is the same.

In fact MSDN/BOL regards them to be...

Replace the occurrences of ', (@myvar)' in your code with ',' + @myvar. 🙂

--SJT--

After navigating to your link, it's shown as a how to for an order management database. That being the case, that Product table is a reprehensible thing to be showing...

I've been noodling around with music since age 8. I consider music to be my only 'formal education'.

I've done most woodwinds, but the only instrument I continue to play is...

Ack. Trailing spaces. Right.

--SJT--

Well, the SQL statement is syntactically correct. I would still point a finger at the source data having those several different 'formats'. Two things to help troubleshoot, and one silly...

sonia,

Aha! And here I was trying to duplicate the text of your error by manipulating everything but the row terminator in the source file. A little knowledge gained for me.

Good...

sonia,

Well, then this is almost certainly a problem with the data in the source file. You might want to try using int instead of smallint to test the contents of...

Given the correction you noted, the code works as expected for me. The error...

I see that the forums program takes issue with the newline character. Are you using newline for the ROWTERMINATOR?

ROWTERMINATOR = '' --Can't get the newline to show up here. Someone...

What type is defined for the data in column 3? Also, are you using a format file or just letting BULK...

The first line of the error seems to indicate a difference between the data in the file and how it is defined in either the target table or the format...

Latheesh,

The question, as posed, can't be answered. We need more information before we can assist.

For example: is the precision of the desired output known? Can the precision of the input...

Hmm,

Are you adding the value CompanySnapShot.DivId (or some other expression) into the GROUP BY clause of the query I provided? That would show an additional row in the result for...