Soldato
- Joined
- 30 Sep 2005
- Posts
- 16,623
Hi,
SQL Guru required please,
Basically I need the location field in DB2 to be the same as the portdescription field in DB1.
The data is all available to match the records, but I do not have any SQL experience to write the correct query. Hell, I don't
even know how to create the scheduled job lol
I was originally going to code it all in VBScript but when I looked at it, I think a SQL query would do it.
Help!!
Thanks!!
DB1 on SERVER1
--------------
dbo.UDT_Port - (portdescription, macaddress)
DB2 on SERVER2
--------------
dbo.networkinfo - (resourceid, macaddress)
dbo.resourcelocation - (resourceid, location)
SQL Guru required please,
Basically I need the location field in DB2 to be the same as the portdescription field in DB1.
The data is all available to match the records, but I do not have any SQL experience to write the correct query. Hell, I don't
even know how to create the scheduled job lol
I was originally going to code it all in VBScript but when I looked at it, I think a SQL query would do it.
Help!!
Thanks!!
DB1 on SERVER1
--------------
dbo.UDT_Port - (portdescription, macaddress)
DB2 on SERVER2
--------------
dbo.networkinfo - (resourceid, macaddress)
dbo.resourcelocation - (resourceid, location)