HELP with CTE or a Cursor to update multiple rows in 1 table ..selecting from Multiple databases
Server A Syetemtable of Dbname= ABC Dbname productid ABC 123 Syetemtable of Dbname= XYZ Dbname productid ABC 987 Syetemtable of Dbname= AQW Dbname productid AQW 123456 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 DBName product ID ABC NULL XYZ A9065 AQW mailto:33c@1442 these 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 DBName product ID ABC 123 XYZ 987 AQW 123456