HELP with CTE or a Cursor to update multiple rows in 1 table ..selecting from Multiple databases
Server A Syetemtable of Dbname= ABC DbnameproductidABC123 Syetemtable of Dbname= XYZ DbnameproductidABC987 Syetemtable of Dbname= AQW DbnameproductidAQW123456 Like we have 1000 DB’s in Server A and each db has a system table 1 Main LOGIN info table in Server A Dabatase DB1 SELECT * from DB1. DBO.LOGIN table DBNameproduct IDABCNULLXYZA9065AQW33c@1442these rows in 1 main Login table are not matching the system table rows of each individual Databases Now I want to update 1 Main LOGIN info table in Server A Dabatase DB1, so that I get results matching each login table of all db’s SELECT * from DB1. DBO.LOGIN table DBNameproduct IDABC123XYZ987AQW123456
Server A Syetemtable of Dbname= ABC DbnameproductidABC123 Syetemtable of Dbname= XYZ DbnameproductidABC987 Syetemtable of Dbname= AQW DbnameproductidAQW123456 Like we have 1000 DB’s in Server A and each db has a system table 1 Main LOGIN info table in Server A Dabatase DB1 SELECT * from DB1. DBO.LOGIN table DBNameproduct IDABCNULLXYZA9065AQW33c@1442these rows in 1 main Login table are not matching the system table rows of each individual Databases Now I want to update 1 Main LOGIN info table in Server A Dabatase DB1, so that I get results matching each login table of all db’s SELECT * from DB1. DBO.LOGIN table DBNameproduct IDABC123XYZ987AQW123456 Read More
