begin transaction
UPDATE A
SET FUL_CENTER_FLG = 'Y'
FROM S_ORG_EXT A, EIM_ACCOUNT B
WHERE B.LOC = A.LOC
AND A.ROW_ID NOT IN
(SELECT C.TARGET_OU_ID FROM S_EVT_ACT C)
--check the data and commit / rollback accordingly
RE: Combo box bound field change ... Modify the row source to include both fields. ... Make the bound column the company name column. ... now you can change the company name any time and your query... Make a copy of your transaction table, but copy only the structure, not the ... (microsoft.public.access.forms)
Re: Transaction Isolation Level ... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ... (comp.databases.ms-sqlserver)
RE: Combo box bound field change ... now you can change the company name any time and your query... Make a copy of your transaction table, but copy only the structure, not the ...Modify the New transaction table and change the company name field to ... I'd run a report to show what all that company purchased. ... (microsoft.public.access.forms)
RE: Combo box bound field change ... You do want the companynbr field rather than the company ... now you can change the company name any time and your query... Make a copy of your transaction table, but copy only the structure, not the ... I'd run a report to show what all that company purchased. ... (microsoft.public.access.forms)
Re: Transaction Isolation Level ... This means that while I initiate a transaction selecting all new orders it ... is possible for others to add other new orders to the database which I will ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ... (comp.databases.ms-sqlserver)
