CODEWITHSUNDEEP
sqlsql-server
Pepe
Pepe

Reputation: 423

Save data of subquery into temporal table

I have this query:

SELECT * 
FROM ##TGJAE  
WHERE Asiento IN (SELECT SUBLEDGERVOUCHER  
                  FROM GENERALJOURNALACCOUNTENTRY AS GACE
                  INNER JOIN GENERALJOURNALENTRY AS GJE ON GJE.RECID = GACE.GENERALJOURNALENTRY 
                  WHERE POSTINGTYPE = 31
                  GROUP BY SUBLEDGERVOUCHER 
                  HAVING COUNT (*) > 1)

I want to save result of this query into temporal table. How can I achieve that? Regards

Upvotes: 0

Views: 103

Answers (3)

Md. Suman Kabir
Md. Suman Kabir

Reputation: 5453

Try this :

SELECT * INTO ##YOURTEMPTABLE FROM  ##TGJAE  WHERE Asiento IN (SELECT SUBLEDGERVOUCHER  FROM GENERALJOURNALACCOUNTENTRY  AS GACE
INNER JOIN GENERALJOURNALENTRY AS GJE ON GJE.RECID = GACE.GENERALJOURNALENTRY WHERE POSTINGTYPE = 31
GROUP BY  SUBLEDGERVOUCHER HAVING COUNT (*) > 1 
)

Upvotes: 0

Icarus
Icarus

Reputation: 63962

Like this:

SELECT  *
INTO #TEMP_TABLE
FROM    ##TGJAE
WHERE   Asiento IN (
        SELECT  SUBLEDGERVOUCHER
        FROM    GENERALJOURNALACCOUNTENTRY AS GACE
                INNER JOIN GENERALJOURNALENTRY AS GJE ON GJE.RECID = GACE.GENERALJOURNALENTRY
        WHERE   POSTINGTYPE = 31
        GROUP BY SUBLEDGERVOUCHER
        HAVING  COUNT(*) > 1 );

Upvotes: 1

Dale
Dale

Reputation: 1941

You can use select * into #temptable like so:

SELECT * INTO #TEMPTABLE FROM ##TGJAE  WHERE Asiento IN (SELECT 
SUBLEDGERVOUCHER  FROM GENERALJOURNALACCOUNTENTRY  AS GACE
INNER JOIN GENERALJOURNALENTRY AS GJE ON GJE.RECID = GACE.GENERALJOURNALENTRY 
WHERE POSTINGTYPE = 31
GROUP BY  SUBLEDGERVOUCHER HAVING COUNT (*) > 1 
)

Upvotes: 1

Related Questions