[UL_CreateAccount] AS TRUNCATE TABLE UL_Account INSERT INTO UL_Account SELECT COALESCE (dl.AccountId,CAST (NULL as uniqueidentifier)) as AccountId, ac.Name, cu.TransactionCurrencyId as CurrencyId, ...