<laugh> Wow, where was my thought process when I was writing that? Thanks for pointing out my error and correcting it.
Quote:
Originally Posted by TRYDL
Code:
JOIN Inv_AeX_AC_TCPIP z
ON z.[IP Address] = i._ResourceGuid
can't join on that, an IP address wont match to an object GUID 
try
on z._ResourceGuid = i._ResourceGuid
If that air lookup doesnt work, I'll throw it into SSMS and write it up for you. |
