Is it possible to start a transaction inside another transaction ?
Should I specify a particular isolation level ?
Any ideas or tricks are welcome.
ThanXYes you can have nested transactions.
When I have complex work to perform or cascading delets, I set IMPLICIT_TRANSACTIONS to on and then manage commits/rollbacks myself. Otherwise I stick to AUTOCOMMIT.
I would encourage you to look up "transactions, described" in Books On Line.
Showing posts with label level. Show all posts
Showing posts with label level. Show all posts
Friday, March 30, 2012
Imbricated transactions
Labels:
database,
ideas,
imbricated,
inside,
isolation,
level,
microsoft,
mysql,
oracle,
particular,
server,
specify,
sql,
transaction,
transactions,
tricks
Friday, February 24, 2012
Iif MDX Strings
Hi
Have the following Code
Iif([Practices].currentmember.level.name="All Practices",
string1 espression,
StrToValue([Practices].currentmember.Properties("Normalised"))
Currently when I browse the data for the All Practices Level I get #ERR.
For the levels below (known as PCT) I get values.
What do I need to enter into the string1 esporessiom part so that it gives me the sum of the 2nd level.
ie: If level 1 = All Practices, give me the total of ther normalised values from the PCT level, else give me the normalised value as is....ie:
If PCT1's normalised value = '1000'
and PCT2's normalised value = '2500'
Then I want the All Practices level to show 3500 and not #Err
Subscribe to:
Posts (Atom)