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

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

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

Answers

disply multiple new columns using sql server

Prasad Bhagat

10y

1.1k

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

Answers (2)

Next Recommended Forum

how to join two tables problem

How to get large data from sql server in 2 seconds

Leaderboard

View all

Mahesh Chand

Vijay Pratap Singh

George

View all

Yesterday's leader

Mahesh Chand

Startup Advisor, Speaker, Author, Architecture, Innovation

Philadelphia (USA)

241.5m

271k

Member of the month

Mark Pelf

Belgrade (Yugoslavia)

187

289.3k

10.5k

500

Speaker of the month

Magnus Mårtensson

ASP.NET, .NET, C#, JavaScript, Azure

Sweden

18.3k

58.5k

Upcoming events

View all

Suggested for you

View all

Javeria Tabassum

Praveen Kumar

Abhishek Singhal

Sagar Lad

Sravya

Forum Statistics

Please welcome our newest member Jhonny Angeles Rivera Mendoza.
3,077,313 users have contributed to 147,418 threads and 483,387
In the past 24 hours, we have 8 new threads, 21 new posts, and 146 new users.
In last week, the most popular thread is 'Case statement Else part Not Working Properly .'.