I will try the cursor. The set based option works for when I want to do all customers but is significantly slower when I need to do only one...

Everything is on that screen is UI. I want to know how to do it in an .SQL file that can be run.

Mike

Paul,

Do I need to do an explicit Begin Trans / Commit to make sure there is no duplicate sequence #'s?

Mike

Chad,

Thank you for your help. I will adapt the code to work for me.

Mike

Actually, I am the vendor and I don't have the time right now to rewrite all the code to handle identity columns. Currently, the code has to 'generate' the...

I have legacy code that does not allow for identity columns, thus I have a table that holds the last "PK" value. I am getting occasional update issues. ...

I have been doing some performance testing and I am beginning to think temp tables aren't so hot. I have one area where I insert into the table 1...

mister.magoo:

I don't understand how to use the profiler. Could you point me to a good resource.

Thanks.

Jeff Moden (6/23/2010)

---

Correct... the Tuning Advisor cannot see temp tables because they're usually created in another session. You'll need to make the table materialize while you're trying to do...

It is only one SQL server. The time difference is between running the query locally and running the query on a machine attached via the network.

Currently, the network is...

steveb. (6/17/2010)

---

It depends on a number of things,

-your statistics could be different on the machines,

- there could be other things running.

- you may not have been...

legacy code issues. Need the primary key for child record(s).

Jeff,

What would you recommend to make sure I don't get duplicate primary keys? Should I do it as a standard proc?

Mike

Lamprey13 (5/21/2010)

---

I'm not sure if that is possible. But, even if it is possible, that sounds like a really bad idea.

Have you investigated using a "listener" app that reads unprocessed...

Jeff,

The connections close when I close the exe. I have tested this issue by issuing an INSERT command in the command window. It hangs until I use...