Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mulitple inserted rows during high transaction periods?

Status
Not open for further replies.
RonPro

RonPro

Programmer
Apr 10, 2002
74
US
Is it possible in SQL2K to have multiple rows in the inserted table during times of high transaction processing?

I have an instance where I need to use the inserted table to update other columns for the row that was updated. It seems to me that in a previous project I had to deal with this by using a local cursor but I'd like to avoid this if possible. (I think the original might have even been on a 7 installation).

TIA (I Searched on inserted but didn't see anything relating to this)
 
Status
Not open for further replies.

Similar threads

SashaBuilder3
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
428
SashaBuilder3
SashaBuilder3
peac3
  • Locked
  • Question
Consolidate multiple rows into single row 1
Replies
4
Views
497
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
723
Chris Miller
Chris Miller
Brianfree
  • Locked
  • Question
return unique rows only
Replies
11
Views
263
Brianfree
Brianfree
briangriffin
  • Locked
  • Question
Calculating differences every two rows
Replies
2
Views
218
kjv1611
kjv1611

Part and Inventory Search

Sponsor

Back
Top