Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get Your SQL Server Questions Answered at ASK.SQLServerCentral.com

image

While the SQLServerCentral.com forums have always been a popular way to get your SQL Server questions answered, and to participate in the greater SQL Server Community, SQLServerCentral.com is now offering a new feature called Ask.SQLServerCentral.com, 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 Ask.SQLServerCentral.com and the regular SQLServerCentral.com forums is that Ask.SQLServerCentral.com 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 Ask.SQLServerCentral.com.

Comments

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_EMPLOYEE (Employee)

ATNSHT_IN_TIME(In-time)

ATNSHT_OUT_TIME(Out-time)

ATNSHT_TOTAL_HRS(Total Hours)

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.