This query checks population totals for ACS 2014 and Census 2000.

EJ_2016_ACS_C2000_Pop_Check.sql

SELECT        Count(geoid) as [Total Tracts], SUM(TotalPopulation) AS [Total Population]
FROM            [EJ_2016].[ACS_2014_EJ_Selected_Variables]

--Has the correct number of tracts
SELECT       Count(geoid) as [Total Tracts], SUM([TotalPopulation]) AS [Total Population]
FROM            [EJ_2016].[CENSUS2000_EJ_SELECTEDVARIABLES]

SELECT        Count(geoid) as [Total Tracts],SUM([Total_pop]) AS [Total Population]
FROM            [EJ_2016].[CENSUS2000_EJ_SELECTEDVARIABLES]

SELECT        Count(geoid) as [Total Tracts], SUM([TotalPop_ACS2014]) AS [Total Population]
From [EJ_2016].[EJ_Select_Variables_ACS2014_Census2000_Compare]