CODEWITHSUNDEEP
sql-server-2012
Melvuen
Melvuen

Reputation: 5

how to insert query result to a temp data in SQL

I want to know how to store my query below into a temp data from SQL, 

SELECT DISTINCT TOP 10 
    Xdate, Xhostname, COUNT(Xhostname) AS total 
FROM
    weblogs 
WHERE
    Xdate  
    AND xhostname IS NOT NULL
GROUP BY 
    Xhostname, Xdate 
ORDER BY 
    total DESC

SELECT distinct top 10 Xdate, Xuser, count (Xuser) as total 
FROM weblogs 
WHERE Xdate and Xuser is not null 
GROUP BY Xuser, Xdate 
ORDER BY total DESC

SELECT distinct top 10 Xdate, Xsrcip, count (Xsrcip) as total 
FROM weblogs 
WHERE Xdate and Xuser is not null 
GROUP BY Xsrcip, Xdate 
ORDER BY total DESC

Thanks in advance

Upvotes: 0

Views: 937

Answers (1)

Sam
Sam

Reputation: 910

CREATE TABLE ##tempTab (Xdate datetime, XUser VARCHAR(100), Total INT)

INSERT INTO ##tempTab
SELECT DISTINCT TOP 10 
    Xdate, Xhostname AS , COUNT(Xhostname) AS total 
FROM
    weblogs 
WHERE
    Xdate  
    AND xhostname IS NOT NULL
GROUP BY 
    Xhostname, Xdate 

UNION
SELECT distinct top 10 Xdate, Xuser, count (Xuser) as total 
FROM weblogs 
WHERE Xdate and Xuser is not null 
GROUP BY Xuser, Xdate 

UNION

SELECT distinct top 10 Xdate, Xsrcip AS XUser, count (Xsrcip) as total 
FROM weblogs 
WHERE Xdate and Xuser is not null 
GROUP BY Xsrcip, Xdate

Upvotes: 2

Related Questions