Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get Your SQL Server Questions Answered at


While the forums have always been a popular way to get your SQL Server questions answered, and to participate in the greater SQL Server Community, is now offering a new feature called, which is a new way to find answers to your SQL Server questions. You can either find a question that already has answers, or ask any question that has not been covered.

The major difference between and the regular forums is that focuses on questions and answers, and not the social community aspects of the forums. In addition, it is built upon the popular Stack Exchange codebase, which allows the best answers to questions to be highlighted, helping you to focus your time on reading the best answers, and avoiding the chaff.

So the next time you have a SQL Server question you need answered fast, and with authority, ask it at


Posted by rachana.libra on 16 March 2013

Hello Everyone,

I have table of Attendance of Employee.

ATNSHT_ID (Attendance ID)

ATNSHT_ATTEN_DATE(Attendance  Date)





ATNSHT_ATT_STATUS(Status means Absent(A) or Present(P))

I am using SQL server 2008 R2

I want to create an SP which display the Employee Attendance ,When i enter the particular month and year.

The result I want is Employee Name in Row and Month Days in Column and in that column A for Absent and P for Present .

Please Can anyone help me???

Leave a Comment

Please register or log in to leave a comment.