• 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