insert into [dbo].[ProxyWebAppCounts] select SiteName, count(*) [WebAppCount] from [dbo].[ProxyWebApps]