User Profile
Collapse
Profile Sidebar
Collapse
jrsonner
Last Activity: Mar 7 '08, 03:58 PM
Joined: Mar 4 '08
Location: Yorkville, IL
-
Yes I am going to import the data for the ST_page table before the migration into the SQL instance as a different database. I do not want to interfer with the production database. I do need to update the ST_page table in the production database with the ST_page table information from before the migration which I thought the best way was to import that table into a different database. Both tables with then be in the same instance of SQL just not in... -
Trying to create a Update query to update data from one table to another
I have multiple entries in one table that I need to update the entries in the current production table with, to revert that data back before a migration so I can migrate that data again.
The queries I wrote to find the entries that need to be updated is below. There are four queries that I ran to find the information. There is a total of about 2500 lines that need to be updated.
Select * from St_Page
where fname...
No activity results to display
Show More
Leave a comment: