this kind of request ranks up there with a request that was once heard at Enron:

Run everything in these filing cabinets through the shredder...boss said it was ok, and those...

blocking is not affected by users...it's affected by two connections selecting and updating the same row of at nearly the same time.

...whether it is two connections with the same...

i'd think it through first...what happens if the database goes missing? does the company shut down? is the database being used? maybe they mean they want you to move the...

the switches we are talking about are for the program bcp.exe, not xp_cmdShell...easy to confuse

i would reckon books online has a complete description of each delimiter, but the command line...

when i did bcp /? from a command window, i saw one if the switches is a lower case t:

[-t field terminator]

changing my command to this gave me comma delimited...

keyun this example works for me... outputs 3 rows to my file:

no quotes or spaces for the username or password bvariables being passed...your way may work, but it's not how...

wierd i got the same error, not sure if it is because of the reserved word SITE or not;

this passes the syntax check:

select cust_num,slsman,

SUM(CASE WHEN [site] = '11199' THEN...

edited because now i'm not so sure......

Trusted_Connection=yes = I thought was not possible...unless you change the login used for the SQL Service account.

I know SQL does not use YOUR credentials...

instances use the other slash...dunno if it is a typo:

my server is LOWELL\SQLEXPRESS, or LOWELL\SQL2008 for my other instance....could that be the issue?

well i saw one thing we can fix right away so far:

there is a scalar function dbo.Get_LocalDateTime that is called multiple times; that needs to be changed to a inline...

keyun i'm sure the issue is related to attempting to use a trusted connection.

if you pass a SQL username and password, your command to bcp via xp_cmdShell will owrk.

to see...

sam-1083699 (6/24/2010)

---

HI Friends,

I'm currently working on a server where lot of transactions will be running and this server is a very beefy server with 4 quadcore processes for a...

you cannot use a trusted connection via sp_cmdShell. SQL doesn't use your credentials after you've connected to SQL.

this is a common security misconception. The problem is that when you...

you do not need to put the command in a while statement; .Replace will replace all instances of the comma in one single function call.

there is a Connect article about how Raiserror does not work the same with XACT_ABORT ON as it does when in a try catch block:

http://connect.microsoft.com/SQLServer/feedback/details/275308/have-raiserror-work-with-xact-abort

annoying, you would expect raiserror to...