disply multiple new columns using sql server

Sign in to answer this question.

• 

  Ranjit Powar12y agoPosted Oct 1, 2014, 12:30 AM

  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 Kumar12y agoPosted Sep 30, 2014, 8:20 AM

  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