Table TEMP for BIG Tables(ROWS)

SELECT

    {TRANSACTION}.[Id],{TRANSACTION}.[PostDate],

    {TRANSACTION}.[Iban], {TRANSACTION}.[Amount]

INTO #TEMP

FROM {TRANSACTION}

WHERE {TRANSACTION}.[Nconta]= <variable>

SELECT #TEMP.*

FROM #TEMP