While getting some data input, for below query, encountered Convertion failed error:-
SELECT a.ProcessInstanceAppianID,
a.ProcessInstanceDescription,
CONVERT (INT, RIGHT(a.ProcessInstanceDescription, 6))AS KPI,
i.KeyPersonKPILead,
p.BestPersonName AS 'Lead Person'
FROM InternalUseOnly..processinstance a
LEFT JOIN InternalUseOnly..ProjectInput i
ON i.KeyProjectInput = CONVERT (INT, RIGHT(a.ProcessInstanceDescription, 6))
LEFT JOIN snledit..Person p
ON p.keyperson = i.KeyPersonKPILead
AND p.UpdOperation < 2
WHERE a.KeyProcessStream = 1827
AND a.ProcessInstanceCompleted IS NULL
AND a.UpdOperation < 2
It would be very aiding & adding, if anyone can guide me here.
Thanks in anticipation!