I figured it out... I feel silly....

I didn't declare my @so_wr_dt parameter as a datetime.

It works now!

PurpleLady (3/30/2011)

---

CR & LF will not show in Query Analyzer (I've had to do some fancy footwork to remove CR & LF from my data), but if you print...

Still on the same line...

I may just keep it that way, although I really would like it to be on a new line....

I tried running the query in Text mode and it looks like it is on the same line there as well...

GSquared (3/28/2011)

---

It's usually better to handle that kind of formatting in the application/presentation layer, but if you have to do it in the query, it can look like this:

coalesce(

ship_to_addr1 +...

WayneS (3/11/2011)

---

donato1026 (3/11/2011)

---

Sorry, but I won't be able to do that. This can be used on any...

Sorry, but I won't be able to do that. This can be used on any database ....

Anyone?

Thanks, Dan. . . But it's still not working, even with Lowells code. . .

OLE DB provider "SQLNCLI" for linked server "06websql\websql" returned message "Deferred prepare could not be completed.".

Msg...

Thanks, Dan. However, this is not working either. . . I am receiving the following:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'SET FMTONLY OFF; EXEC (declare...

Thanks, Lowell, but it's not working. . .

I'm getting this:

OLE DB provider "SQLNCLI" for linked server "06WEBSQL\WEBSQL" returned message "Deferred prepare could not be completed.".

Msg 8180, Level 16, State 1,...

🙂

This worked! Thank you!

I was about to throw my desk through the wall. . .

Lowell (5/20/2010)

---

Donato this is how i usually update a table from multiple sources...note the commented SELECT statement so i can run the bottom portion to test before and after:

SET XACT_ABORT...

Never mind. . . I got it to work. I was using servername.dbo.table name - rather than databasename.dbo.tablename. It works now!

Now. . . Is there any way to have it...