If you right clink on the table you wish to insert values into and select script table as > Insert > New Query Editor Window, you will get something like...

Depending on how quickly the trace files fill up (they are set to grow to a specific size then rollover) and how often you backup those files, it is possible...

Me thinks someone is in a bit of pickle here.

Gail, you may want to see if you could help. I can't think of much off hand.

No much we can do with the update statement since it joins to a view. We would need to see the DDL for the view and the underlying tables...

JC-3113 (5/14/2013)

---

Hi Jeffrey

thanks for the input

that takes me back to my original issue

I am rebuilding indexes on sat night after my full back up

what happens then is that my differentials...

Use SUBSTRING or LEFT to only pull the first 50 characters from the source column.

Making it easier for others:

http://support.microsoft.com/kb/244474

http://support.microsoft.com/kb/327825

Use Google or Bing, I only wrote the Oracle database code, not the code that accessed it.

If you are doing...

sqlfriends (5/14/2013)

---

Lynn Pettis (5/14/2013)

---

I'd probably have the application do the update, but that's just me. The app could be coded such that the update needs to occur in both...

asaini (5/14/2013)

---

the results I get are currently something like this:

Sales Order NumberAccount NumberLines Per Order

19319-02711

17987-02711

19148-02711

19052-02711

19052-12711

19545-02711

19564-02711

19704-02711

19030-02711

19661-02711

19662-02711

19662-12711

SO-4343 271 3

SO-4313 271 ...

zouzou (5/14/2013)

---

Yes they are the results of a huge sql process that does a lot of things, and the results are diplayed but cant go through them since they are...

Not much to go on here, especially since we can't see what you see. Care to provide more details, perhaps even post the code for the proc?

I'd probably have the application do the update, but that's just me. The app could be coded such that the update needs to occur in both or fail if...

Eugene Elutin (5/14/2013)

---

Lynn Pettis (5/14/2013)

---

Eugene Elutin (5/14/2013)

---

William Gary Wright (5/14/2013)

---

I left the office last night being half way done writing a script to create a database with some data in...