SQL guru required please!

[glenimp617]

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)

 

[glenimp617]

Brilliant, thanks guys

The data needs to be regularly updated, once a day will do

Remember the macaddress is in a different table in DB2 to where the location is set so was unsure how the matching would work

 

[glenimp617]

They will be linked (joined) by the resourceid.

Yes, which is why I think the code above is incorrect