Sql updating multiple tables simultaneously
Here are the 3 update queries I tried and got the same error each time.
Customer Sales is a linked table (the source table - data came from this table).
I came across this error when I was trying to update data in a local Access table by using the matching data in a linked table in Oracle.
If the two tables are both local Access tables, my update query is fine to run and can correctly update the data in the target table, but because one of the tables (the source table in my case) was a linked table, I kept getting this error.
I want to keep the rows consistent for that identity number between the two tables.
I know this code doesn’t work, but if it did, this is what it would look like: Table: MAIN_TABLE m1Columns: C1, C2, C3, C4, C5, C6, C7, C8, C9, C10, C11, C12Table: TABLE1 t1Columns: ID, E1, E2, E3, E4, E5, E6Table: TABLE2 t2Columns: ID, E7, E8, E9, E10, E11, E12 INSERT INTO TABLE1, TABLE2(t1.
But at any rate, I appreciate your help and examples. Ronnie create table #abc( col1 int identity, col2 varchar(10))create table #bbb( col1 int, col2 varchar(10))insert #abc (col2)output inserted.col1, inserted.col2 into #bbb select 'My Value'select * from #abcselect * from #bbbdrop table #abcdrop table #bbb _______________________________________________________________Need help? Read the article at Practices/61537/ for best practices on asking questions. My task was to move those note columns into their own table to improve performance. I need to play around with your methods to see that that will work. Cross Tabs and Pivots, Part 1 – Converting Rows to Columns Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs Understanding and Using APPLY (Part 1)Understanding and Using APPLY (Part 2) Thanks for this. My situation was that I have inherited a 372,000,000 row OLAP table that has several note-type columns in it. And it's not a precise split either as well as for a couple columns, there are conditions on which column to use for that data which will probably result in the use of a CASE statement.update Customer Sales_Retail as a inner join ( select x. Sales Date from Customer Sales as x inner join Customer Sales_Retail as y on x. Uniqueness prohibits duplicated values in the column(s).Secondly, if the source table is a linked table, we can resort to a two-step process.