Do it like this:

WITH CTE_Test (ID)

AS

(

SELECT CAST(id AS VARCHAR(60)) FROM cat_transaction

EXCEPT

SELECT ext_reference FROM Patricia.dbo.BUDGET_LINE

)

SELECT @Total = COUNT(ID)

FROM

CTE_Test;