You might be able to get away with the following:
INSERT INTO HFM_Auxiliar.dbo.HFM_Applications (Appname)
SELECT DISTINCT Appname
FROM hfm.dbo.HSX_DATASOURCES
EXCEPT
SELECT DISTINCT Appname
FROM HFM_Auxiliar.dbo.HFM_Applications
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)