i have sp that store data in three tables, t1, t2, t3
till the transaction is commited no record will be inserted.
if i store a value to the t1 table, i can fetch the idx number using scope_idenity() but not physcial record will inserted till commit tranaction.
How do i save this idx number so that i can keep it till it commits transaction. imust store this globally becuase this sp will called by a client application consequtivly four times. but it does not commit tranaction till it complete four iterations. therefore
i need to save the idx generated from the first call to it?
i was thinking about creating a temp table and store the idx in there. but
1. does create seperate temp table for each call tothe sp, (think interms of multi user enviorement)
2. what sort columns that i should create in thsi temp tabel
3. is temp table a good option?
View Complete Post