-- Get Process Name by Process Instance ID
USE K2 -- Adjust your K2 DB name if necessarry
DECLARE @PInstID INT
DECLARE @ProcID INT
SET @PInstID=1 -- Specify your Process Instance ID Here
SET @ProcID = (SELECT ProcID FROM Server.ProcInst WHERE ID=@PInstID)
SELECT [Name] FROM Server.[ProcSet] WHERE ID = (SELECT ProcSetID FROM Server.[Proc] WHERE ID=@ProcID)