on area where I have been back to #table is after CTE

eg

;WITH cte_OldTraders (TRID, LastSOdate)

AS (

SELECT traderid, MAX(orderdate)

FROM salesorders

WHERE status != N'CANCELLED'

GROUP BY traderid

)

--

SELECT customers.idAS xtrid

,isNull(LastSOdate,customers.createddate)AS xsdat

INTO #soldtraders

FROM customers

LEFT OUTER JOIN cte_OldTraders ON (customers.id = TRID)

WHERE [tradingstatus] = N'CURRENT';

--

BEGIN TRAN

UPDATE traders

SET [tradingstatus] = N'DORMANT', [isonhold] = 0

FROM traders

INNER JOIN #soldtraders ON (id = xtrid)

WHERE [dbo].[xfn_julian_date](xsdat) < 3400 -- aging Function

COMMIT TRAN

I could not get @soldtraders working

so it is GOOD to have knowledge of both