disply multiple new columns using sql server

Sep 30 2014 5:58 AM

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)