PIVOT() is used to convert the rows to columns in SQL Server. The example as give below. 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
Angular, React, JavaScript, Java, PHP, SQL, C#, Vue, NodeJs, TypeScript and Interview Questions Answers