What this proc really does is get details for various amounts of orders (Could be 1 or 1000) and build a @Body(varchar) so I can write it to a txt...

Both Cursors call data from different tables than the inserted/updated table.

For some reason it won't update the row/s that were inserted within that currrent cursor. If I write a generic...

Okay here is the gist of it. In the nested cursor I am updating the same table that the main cursor inserted into. This happens if there is bad data...

It's a lot of code. You really don't want to go thru all of it. I'll post code that essential does the same thing.

Thanks for the replies.

Yeah I noticed the missing WHERE Clause in the update statement.

I've used similiar code and it hasn't generated any deadlocks that I was aware of. If it...

Okay I found the answer to the next line problem... I wasn't including Char(10) with my CHar(13) at the end of my lines.

Char(13) will produce a new line in...

Okay so I found out some more info about sp_OACreate and the methods...

I was able to write a txt file with this using my @Body output param. The only problem...

Hallelujah!!!!

That worked!!!

Thanks to all that helped.

Mr. Jones,

Thanks for the reply.

I tried the DOS shortname and it didn't work.

EXEC master..xp_cmdshell 'osql -E -Q"select top 1 * from t_Table"-o \\MachineName\c$\ToDo~1\output.txt'

I got the Usage Flags...

Ziminski,

After I read your suggestion I did try the > (redirection) symbol.

Not sure if my code is correct:

EXEC master..xp_cmdshell 'osql -E -Q"select top 1 * from t_Table"-o >\\MachineName\c$\To Do\output.txt' ...

Thanks for the reply.

I noticed you could create a txt file that way during my research. Problem is that's a bit to simple for what I'm trying to do. I...

Thanks for the reply....

I actually just tried the CD command without quotes and it worked.

C:\>CD documents and settings\all users

it also works with quotes:

C:\>CD "documents and settings\all users"

I'm on XP SP2.

I...

Lester thanks for the reply.

Yeah I tried it before by declaring it in the OSQL command and it worked. I was hoping there was another way. Not sure why...

Not sure exactly what your trying to accomplish but I just got done writing a Phoentic Name search that our employees use to find existing customers in our system...

They can...

Thanks for the reply.

I had to figure out how to use the option first 🙂

That worked. It resulted in a query of about 1 sec again.

Thanks!

Now my question...