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 int,ANNUAL_LEAVE int,WEEKLY_OFF int,COMP_0FF int) Insert into Temp1(WORKDAYS,ANNUAL_LEAVE,WEEKLY_OFF,COMP_0FF  )Values (@workDays,@annalLeave,@weeklyOff ,@compOff ) Select *from Temp1 Drop table  Temp1
End

Abhishek Kumar · 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