I do not know if this comment references the application in question but one...

I do not think this is a 'more personal approach' issue. It depends on the partcular case you want to solve. In most cases using the connection pooling is desirable...

It depends on how you have your database access structured inside your app.

If this is a web application you want to utilize the connection pooling and to close the connection...

Doesn't it feel better when you find the solution yourself?

😀

Good luck and come back if you have more issues...

Sorry, had too many meetings.

Let me clarify something.

If I understand properly you want to update the siteID to be the value found in a record with the highest projectID among...

You have to do a self join with a subquery to give you the max.

If you can post some sample code to create a table and insert some sample...

This is 2005 forum

For 2000 you could use this.

SELECT SO.name, COUNT(*)

FROM syscolumns SC

INNER JOIN sysobjects SO ON SC.id = SO.id

WHERE SO.type...

Lucky you my lunch buddy is home sick today so I am having it at my desk.

Gave me the extra time to play with the code. 😀

CREATE TABLE test

(

Accountname VARCHAR(10),

Booknumber INT,

Bookname VARCHAR(20)

)

;

GO

;

INSERT INTO test (Accountname , Booknumber, Bookname) VALUES ('StoreOne', 1 ,'A1')

INSERT INTO test (Accountname , Booknumber, Bookname) VALUES ('StoreOne', 2 ,'A2')

INSERT INTO...

OK,

I think you might be able to pull it off by using temp table. Create a temp table with an identity field, a bit field and all your other fields....

How many rows are we talking about? And how often do you need to run it?

Can you link the 2000 servers to the 2005 server?

Also the five columns you clear...

Bob, after reading your post and re-reading lduvall original post I think I was wrong and what you have is what he needs.

Connection pooling can not span multiple processes. So even if the other application is using the same method accessing the database and the same database they each will have a...

Probably but not necessary. I think it looks simpler. 😀

But looks could be deceiving.

Remember we worked with a much simpler table then the final request. I think...

Gift Peddie,

In the original post it was indicated that the application that uses the global temp table is not the same application that uses the connection pooling (sp_reset_connection). At least...