on 09-17-2014 11:37 AM
hi experts
from bellow query i'm not getting emp last hike date
SELECT T0.[empID], T0.[firstName],T0.[salary] ,T1.[remarks],
(SELECT max (T1.[Date] ) FROM OHEM T0 full JOIN HEM3 T1 ON T0.empID = T1.empID )
FROM OHEM T0 full JOIN HEM3 T1 ON T0.empID = T1.empID WHERE T0.[status] is null AND T0.[termReason] IS NULL
please help me
Thanks & Regards
Andakondaramudu
Hi,
Try this:
SELECT T0.[empID], T0.[firstName],T0.[salary] ,T1.[remarks],
(SELECT max (T1.[Date] ) FROM OHEM T0 left JOIN HEM3 T1 ON T0.empID = T1.empID )
FROM OHEM T0 left JOIN HEM3 T1 ON T0.empID = T1.empID WHERE T0.[status] is null AND T0.[termReason] IS NULL
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try this,
SELECT T0.[empID], T0.[firstName],T0.[salary],Max(convert(nvarchar(max),T1.[remarks])) Remarks,MAX(T1.[Date]) HighDate
FROM OHEM T0 LEFT OUTER JOIN HEM3 T1 ON T0.empID = T1.empID
WHERE (T0.[status] IS NULL) AND (T0.[termReason] IS NULL)
group by T0.[empID], T0.[firstName],T0.[salary]
Thanks & Regards,
silambu
hi silambu
thanks for u r replay ,i did miner changer then it will work fine
SELECT T0.[empID], T0.[firstName],T0.[salary],Max(convert(nvarchar(max),T1.[remarks])) Remarks,MAX(T1.[Date]) HighDate
FROM OHEM T0 left outer JOIN HEM3 T1 ON T0.empID = T1.empID
WHERE T0.[termDate] IS NULL
group by T0.[empID], T0.[firstName],T0.[salary]
Thanks ®ards
Andakondaramudu
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.