SELECT E.EmpId AS EMPID,E.CorporateId AS CORPID, E.FirstName+' '+E.LastName AS NAME, E.AccountNo, --[dbo].[fnMaskCardNo](E.CardNo) as CardNo, ES.Salary AS Amount, CASE WHEN E.FollowMOLWorkFlow!=NULL THEN 'YES' ELSE 'NO' END as WPS FROM EMPLOYEE E,CORPORATE C,EMPSALARY ES WHERE (E.CorporateId='IBM') and ES.SALMONTH=3 and ES.SALYEAR=2014 AND ES.Mode in('U') and C.IsDeleted=0 GROUP BY E.CorporateId,E.EmpId, E.FirstName+' '+E.LastName,E.AccountNo, E.FollowMOLWorkFlow
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)