UPDATE	x
SET	x.PendingAtGlobus = '2'
FROM	tblCancelPolicy AS x
WHERE	x.PendingAtGlobus = '1'
	AND NOT EXISTS (SELECT * FROM tblSubscription AS e WHERE e.GlobusStatus IS NULL AND e.Wings_Status = 'S' AND e.Policy_id = x.Policy_id)


UPDATE		x
SET		x.PendingAtGlobus = '2'
FROM		tblCancelPolicy AS x
LEFT JOIN	tblSubscription AS e ON e.Policy_id = x.Policy_id
			AND e.GlobusStatus IS NULL
			AND e.Wings_Status = 'S'
WHERE		x.PendingAtGlobus = '1'
		AND e.Policy_id IS NULL