• I have read the cross apply articles

    I made the following code to see if I understand it correctly.

    SELECT 'D' AS RECORDTYPECODE

    , a.[Id]

    ,a.[FundsMovementItemTypeId]

    ,a.[FundsMovementSetId]

    ,a.[FeeTypeId]

    ,AccountName = iTVF.result

    ,GLAccountName = iTVF1.result

    ,LodgementReference = iTVF2.result

    ,AccountNumber = iTVF3.result

    ,a.[IsSundryParties]

    , TraceBSB = iTVF4.result

    ,TraceAccountName = iTVF5.result

    ,TraceAccountNumber = iTVF6.result

    ,a.[IsSundryPartiesTraceACC]

    ,a.[IsAttractGST]

    ,a.[IsCustomerAccount]

    ,a.[Amount]

    ,a.[OnDateTime]

    ,AccountBankCode = iTVF7.result

    ,a.[U1]

    ,U2 = iTVF8.result

    ,a.[U3]

    ,a.[U5]

    ,a.[genID]

    FROM %DBNAME%.FundsMovementItem a

    CROSS

    APPLY dbo.ReplaceSplVarcharsBICD_test4(a.AccountName) iTVF

    CROSS

    APPLY dbo.ReplaceSplVarcharsBICD_test4(a.GLAccountName) iTVF1

    CROSS

    APPLY dbo.ReplaceSplVarcharsBICD_test4(a.LodgementReference) iTVF2

    CROSS

    APPLY dbo.ReplaceSplVarcharsBICD_test4(a.AccountNumber) iTVF3

    CROSS

    APPLY dbo.ReplaceSplVarcharsBICD_test4(a.TraceBSB) iTVF4

    CROSS

    APPLY dbo.ReplaceSplVarcharsBICD_test4(a.TraceAccountName) iTVF5

    CROSS

    APPLY dbo.ReplaceSplVarcharsBICD_test4(a.TraceAccountNumber) iTVF6

    CROSS

    APPLY dbo.ReplaceSplVarcharsBICD_test4(a.AccountBankCode) iTVF7

    CROSS

    APPLY dbo.ReplaceSplVarcharsBICD_test4(a.U2) iTVF8