Cacher is the code snippet organizer for pro developers

DECLARE @batchId bigint = 0
SELECT @batchId = MAX(pm.Id) FROM dbo.PIBatchMaster pm WHERE pm.RoleLevel = 'L1'

SELECT * FROM dbo.PI_Engineer pe WHERE pe.BatchId = @batchId
SELECT * FROM dbo.PI_Manager pm WHERE pm.BatchId = @batchId
SELECT * FROM dbo.PI_TowerLead ptl WHERE ptl.BatchId = @batchId
SELECT * FROM dbo.PI_LeadershipTeam plt WHERE plt.BatchId = @batchId