john (10/23/2008)

---

Ouch! That is harsh. I guess I am writing it badly because I don't know all the details on how to write it better and it is...

Nah, I've already got my Char(13)+Char(10)'s in the embedded line-breaks. Char(3) is Control-C. 😀

Duplicate Post. Please do not cross-post.

Please direct all replies to http://www.sqlservercentral.com/Forums/Topic590891-8-1.aspx

It occurs to me that this could be the perfect tool for posters who want to provide sample data to us for their questions.

Glad we could help.

You might try this:

EXECUTE xp_cmdshell '"D:\Folder\Task.exe"

'

If that does not work, then try this:

Declare @dos varchar(4000)

Select @dos = '"D:\Folder\Task.exe"

' + Char(3) + '

'

EXECUTE xp_cmdshell @dos

Who...

How much time does this import take every 30 seconds?

Please give us the...

That does not mean that it is completed. It could be still hanging around trying to read command input from somewhere or something (that will never come, obviously). ...

If you mean, summing for all of the rows, without any group by, then the easiest way is:SELECT SUM(A), SUM(B), SUM(C), SUM(A)+SUM(B)+SUM(C) FROM TABLE

Heh, you are correct. That was a logical error on my part.

How do you know that the process actually completed, if it never returns?

By the way, I would not use the " & Exit". It should not be necessary and it may be what is causing your problem.

When I try to execute this I get "The system cannot find the path specified."

Error code 50000 and up are "User-Defined Errors". Which means that they are not Microsoft's and they are coming from either your organizations own stuff, or from a 3rd...

You could probably...