The Query of Lowell works. Only now i get a value of the total of the table item_keya / snetworkname * 100.
But i use this qeury;
SELECT
sNetworkName,
REPLACE(sNetworkName,'.noc','')
FROM WhatsUp_Assyst_replicatie44.dbo.NetworkInterface
RIGHT OUTER JOIN WhatsUp_Assyst_replicatie44.dbo.device
ON WhatsUp_Assyst_replicatie44.dbo.NetworkInterface.nNetworkInterfaceID = WhatsUp_Assyst_replicatie44.dbo.device.nDefaultNetworkInterfaceID
WHERE REPLACE(sNetworkName,'.noc','') NOT IN (SELECT
REPLACE(item_keya,'.noc','') AS NUMMER
FROM dbo.item
WHERE item_keya IS NOT NULL
AND item_keya <> '')
I want to integrate the qeury what Lowell made. The problem is when i run the qeury above it gives the results colmn (NO name) and i heard i cant use a AS colmn. How can i calculate the qeury what lowell made and but it in ...
The result what i get when i run the qeury above;
Snetworkname
bhg-voip-cm.noc
bhg-voip-g450-1.noc
bhg-voip-iptelfs-03.noc
bhg-voip-s8300-1.noc
bhg-voip-utility-01.noc
bhg-voip-vsp-1-01.noc
(No column name)
bhg-voip-cm
bhg-voip-g450-1
bhg-voip-iptelfs-03
bhg-voip-s8300-1
bhg-voip-utility-01
bhg-voip-vsp-1-01
I have try this syntax;
SELECT
sNetworkName,
REPLACE(sNetworkName,'.noc','')
FROM WhatsUp_Assyst_replicatie44.dbo.NetworkInterface
RIGHT OUTER JOIN WhatsUp_Assyst_replicatie44.dbo.device
ON WhatsUp_Assyst_replicatie44.dbo.NetworkInterface.nNetworkInterfaceID = WhatsUp_Assyst_replicatie44.dbo.device.nDefaultNetworkInterfaceID
WHERE REPLACE(sNetworkName,'.noc','') NOT IN (SELECT
REPLACE(item_keya,'.noc','') AS NUMMER
FROM dbo.item
WHERE item_keya IS NOT NULL
AND item_keya <> '')
AND snetworkname = (select ((count(item_keya) * 1.0 / count(snetworkname) * 1.0) * (100.0)) from item, NetworkInterface
where item_keya IS NOT NULL
AND item_keya <> '')
But i getting a error;
Msg 8114, Level 16, State 5, Line 1
Error converting data type nvarchar to numeric.
because the two tables are nvarchars