it is a double hop issue for sure - when you execute on the server the credentials are available locally so it can access the share - when you go...

using "\n" worked fine for me with your sample file.

WITH (FIRSTROW=2, LASTROW=1000, FIELDTERMINATOR=',', ROWTERMINATOR='\n');

as you state your table is partitioned maybe you can switch out each partition onto a staging table, convert the table (repeat for all partitions, one table per partition) and...

• This reply was modified 4 years, 6 months ago by frederico_fonseca.
• This reply was modified 4 years, 6 months ago by frederico_fonseca.

I work on SQL server 2014 I need to rewrite update statement with best practice CAN I Write it without subquery ?

 UPDATE  FFFFF
 SET...

That's awesome, Frederico!  Thanks for posting that.

It would appear, though, that you actually have to program for the table structure.  Is there anything like the getting data from the...

better option for me would be to use a small powershell script to download the contents and load directly to sql server.

edit: the original link only extracts current year -...

• This reply was modified 4 years, 6 months ago by frederico_fonseca.

kindly supply table and indexed DDL for all tables involved as well as row count for each table - and at same time do tell us why table TPartFeature does...

ssms is not BCP - and what you get on SSMS is in many cases totally out of sync with what  you get with other tools.

on this case SSMs applies...

your expectation may not be what you can generate from sql using BCP - not knowing what options you are using I would advise using

"-c" which will add a \r\n...

why don't you wish to use stuff?

you can use substring - but that will make your code a bit more complex.

on diff note - avoid hardcoding dbnames (use synonyms instead)...

To add to what Jeffrey said - if a CTE is mentioned in the following code 2 or more times it's evaluated and executed as many times. No...

the issue is not the sql itself but the whole combination - your system is likely constrained in memory and was unable to produce a plan for the full query.

the...

Of course it must vs taking locks.

"and use snapshot isolation."  MEGA-HUGE overhead.  SI should only be used...

you don't change the connection manager - you change the connection string that the connection manager uses.

only case where this is not possible is when your connection is a flat...

ahhhh. numbers....

2 situations - long ago, still on mainframes.

some reports were based on Lines of Code written.. so 2 teams each with their own type of code managed to "improve"...