Skip to main content

Download Customize pdf and excel

Convert rows to column


select *
from
(
  select distinct  lm.LeaveDescription, lb.EmpId, usr.UserId,
  usr.UserFirstName +' ' + usr.UserLastName as EmpName, [dbo].[GetBalanceLeave](lb.EmpId, lb.LeaveType) as BalanceLeave  
    from Leave_BalanceLeave lb  
    left join  tm_User usr on usr.EmpId=lb.EmpId
    inner join Leave_Master lm on lm.LeaveId = lb.LeaveType
) as src
pivot
(
  sum(BalanceLeave)
  for LeaveDescription in ([Casual Leave], [Earned Leave], [Sick Leave],[Compensatory Off])
) as piv;




Comments

Post a Comment

Popular posts from this blog

Send mail in asp.net

Send mail in asp.net public bool sendEMail(string leavs, string uniqueCode)         {             try             {                 //string subject = "";                 string emailMsg = "";                 LeavePersistence objLeavePersistence = new LeavePersistence();                 System.Net.Mail.MailMessage Msg = new System.Net.Mail.MailMessage();                 // Msg.From = new MailAddress(currentEmailId);                 Msg.From = new MailAddress(ConfigurationManager.AppSettings["Sender"].ToString());                 DataSet ds = objLeavePersistence.GetEmailContentByEmpId(uniqueCode, "Leave2...
Post a Comment
Read more

Convert row to column

Convert rows to column select * from (   select distinct  lm.LeaveDescription, lb.EmpId, usr.UserId,   usr.UserFirstName +' ' + usr.UserLastName as EmpName, [dbo].[GetBalanceLeave](lb.EmpId, lb.LeaveType) as BalanceLeave       from Leave_BalanceLeave lb       left join  tm_User usr on usr.EmpId=lb.EmpId     inner join Leave_Master lm on lm.LeaveId = lb.LeaveType ) as src pivot (   sum(BalanceLeave)   for LeaveDescription in ([Casual Leave], [Earned Leave], [Sick Leave],[Compensatory Off]) ) as piv;
Post a Comment
Read more