Those cursor procedures are used by ODBC drivers when you're addressing (updating, inserting) more than 1 row.

Because ODBC driver is a normal procedural program it cannot perform set-based data alterations....

I prefer much more simple code:

PRINT Convert(varchar(12), GETDATE() - @BeginTime, 114)

HOST_NAME()

There was mising bit in my previous post.

This one:

:rolleyes:

Strange, when I tried to put "Concatenation function" into "search" field I've got this:

http://www.sqlservercentral.com/Forums/Topic465637-149-1.aspx

You need some practice in using Internet search.

Search this site or this forum for "Concatenate function"

You need first from where?

Mercury is the first from the Sun, but it's the last planet for aliens coming from outside of Solar system. Or second planet for us, sitting...

Can you print and post here command string you're executing?

Command

bcp "SELECT 'WHATEVER'" queryout "C:\TestFile.csv" -c -t"," -r -S"ServerName" -T

overwrites existing files without problems.

Check out "isql utility" article in BOL.

My bcp overwrites existing files with no questions asked.

Are you sure you have "Modify" or "Full Control" permission, not only "Read" and "Write" permissions on that folder?

Jeff Moden (5/27/2008)

---

Even though we all, including the OP, recognize that this is a terrible requirement, has anyone actually come up with a solution that shifts the data left without...

Oh yes! If I tell my plumber I want my toilet in that corner, I would expect my plumber to install the toilet where I want. If he then tells...

', DateUpdated = GetDate() ' + CHAR(13)

🙂

"If the customer wants me to paint the Eiffel Tower with a toothbrush I would, even though I could air spray-paint the sucker. The customer pays and have final decision...

What account starts SQL Server?

Does that accout have write privileges on that folder?