SELECT ISNULL(PVT.JANUARY,'0') AS JANUARY,ISNULL(PVT.FEBRUARY,'0')FEBRUARY,ISNULL(PVT.MARCH,'0')MARCH, ISNULL(PVT.APRIL,'0')APRIL,ISNULL(PVT.MAY,'0')MAY,ISNULL(PVT.JUNE,'0')JUNE,ISNULL(PVT.JULY,'0')JULY, ISNULL(PVT.AUGUST,'0')AUGUST,ISNULL(PVT.SEPTEMBER,'0')SEPTEMBER,ISNULL(PVT.OCTOBER,'0') OCTOBER, ISNULL(PVT.NOVEMBER,'0')NOVEMBER,ISNULL(PVT.DECEMBER,'0') DECEMBER FROM(SELECT DATENAME(MONTH,CREATEDDATE) AS [MONTH],COUNT(*) AS CCOUNT FROM COMPANY WHERE TENANTID=1 AND ISNULL(ISDELETED, 0) <> 1 GROUP BY DATENAME(MONTH,CREATEDDATE) ) AS TMP PIVOT(SUM(CCOUNT) FOR [MONTH] IN(JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER)) AS PVT
Download JSON file for this List - Click on JSON file Countries List, Nationalities and Code Excel ID Country Country Code Nationality Person 1 UNITED KINGDOM GB British a Briton 2 ARGENTINA AR Argentinian an Argentinian 3 AUSTRALIA AU Australian an Australian 4 BAHAMAS BS Bahamian a Bahamian 5 BELGIUM BE Belgian a Belgian 6 BRAZIL BR Brazilian a Brazilian 7 CANADA CA Canadian a Canadian 8 CHINA CN Chinese a Chinese 9 COLOMBIA CO Colombian a Colombian 10 CUBA CU Cuban a Cuban 11 DOMINICAN REPUBLIC DO Dominican a Dominican 12 ECUADOR EC Ecuadorean an Ecuadorean 13 EL SALVA...