disply multiple new columns using sql server

Question

Dear all i have one table the Above data i want show like WORKEDDAYS ANNUAL LEAVE WEEKLY OFF COMP OFF 8 1 1 1 PLEASE TELL ME WHAT IS THE QUERY I WANT WRITE IAM TRYING LIKE BELLOW BUT IAM NOT GETTING RESULT PLEASE TELL ME

Ranjit Powar · Answer

try this Create procedure sp_Demo AS Begin Declare @workDays int Declare @annalLeave int Declare @weeklyOff int Declare @compOff int Select @workDays = COUNT(Status)from demo Where Status='WORKING' Select @annalLeave = COUNT(Status)from demo Where Status='ANNUAL LEAVE' Select @weeklyOff = COUNT(Status)from demo Where Status='WEAKLY OFF' Select @compOff = COUNT(Status)from demo Where Status='COMP OFF' Create Table Temp1 (WORKDAYS intANNUAL_LEAVE intWEEKLY_OFF intCOMP_0FF int) Insert into Temp1(WORKDAYSANNUAL_LEAVEWEEKLY_OFFCOMP_0FF )Values (@workDays@annalLeave@weeklyOff @compOff ) Select *from Temp1 Drop table Temp1 End

Abhishek Singh · Answer

Hi Please modify the query as per your requirement. Select * from ( Select day  status from userdb . dbo . timesheet ) a pivot ( max ( day ) for status in ( WORKEDDAYS  ANNUALLEAVE  WEEKLYOFF  COMPOFF ) pv Hope this will help. Abhishek