SELECT * FROM (
SELECT ArchiveAppraisalID, OriginalAppraisalID, AppraisalType, EmpNumber, (A.FIRST_NAME + ',' + A.LAST_NAME) AS EmpName FROM Reports.Appraisals B JOIN tbl_HRITMasterData A ON A.EMPLOYEE_NUMBER = B.EmpNumber UNION ALL SELECT B.ArchiveMidYear AS ArchiveAppraisalID, B.OriginalMidYearID As OriginalAppraisalID, B.AppraisalType, B.EmpNumber, (A.FIRST_NAME + ',' + A.LAST_NAME) AS EmpName FROM Reports.MidYear B JOIN tbl_HRITMasterData A ON A.EMPLOYEE_NUMBER = B.EmpNumber ) AS CombinedData WHERE (@SearchName IS NULL OR (EmpName LIKE '%' + @SearchName + '%'));
Subscribe to:
Post Comments (Atom)
remove duplicates in an sorted array
using System; public class HelloWorld { public static void Main(string[] args) { int[] ar={2,2,3,3,4,6,6}; C...
-
Points 1.complex page layouts and adherence to code standards. 2.primeNG pagination 3.ngcontent 4.ngdestory(memorylekage) 5.datatransfer wi...
-
OLX, like many large-scale online platforms, employs a variety of data structures and technologies to manage its data effectively. While s...
No comments:
Post a Comment