I am getting an issue when I run this query. It is tell me that Arithmetic overflow error converting nvarchar to data type numeric.
Here is a subset of the query I am running as it is long.
CREATE TABLE NeighbourhoodAverages (ID INT IDENTITY (1,1), Village varchar(50), Neighbourhood varchar(50), Domain nvarchar(max), Question nvarchar(max), Average nvarchar(50), Year nvarchar (50)) INSERT INTO NeighbourhoodAverages (Village , Neighbourhood , Question , Average , Year) SELECT CONCAT(Village, Setting) AS Village , Neighbourhood , 'IcanbealonewhenIwish' as QUestion , 100.0 * Count(Case when CanbealonewhenIwish IN (3.00,4.00) THEN 1 ELSE NULL END) / COUNT(*) AS Average , Year FROM Resident_Survey Group By Village, Setting, Neighbourhood, Year
I am not running create table everytime I just included that so you could see what the table looks like.