Cacher is the code snippet organizer for pro developers

DROP TABLE _Boris.dbo.VIO


SELECT ZR.whse WarehouseID
	,AP.Appid AppID
	,ZR.WhslRoute DeliveryRoute
	,SUM(AppCount) VehicleCount
INTO _boris.dbo.VIO
FROM newcat.vio.AppidZip AP
	JOIN wizmo2005_10.dbo.zip_routes ZR
	  ON AP.Zip = ZR.zip
WHERE AP.Appid IS NOT NULL
GROUP BY ZR.whse
	,AP.Appid
	,ZR.WhslRoute