使用查询将数据插入临时表 [英] Insert Data Into Temp Table with Query
问题描述
我有一个输出当前数据的现有查询,我想将其插入到临时表中,但这样做时遇到了一些问题.有人对如何做到这一点有一些见解吗?
I have an existing query that outputs current data, and I would like to insert it into a Temp table, but am having some issues doing so. Would anybody have some insight on how to do this?
这是一个例子
SELECT *
FROM (SELECT Received,
Total,
Answer,
( CASE
WHEN application LIKE '%STUFF%' THEN 'MORESTUFF'
END ) AS application
FROM FirstTable
WHERE Recieved = 1
AND application = 'MORESTUFF'
GROUP BY CASE
WHEN application LIKE '%STUFF%' THEN 'MORESTUFF'
END) data
WHERE application LIKE isNull('%MORESTUFF%', '%')
这似乎当前以我需要的方式输出我的数据,但我想将其传递到临时表中.我的问题是我对 SQL 查询很陌生,并且无法找到这样做的方法.或者,如果它甚至可能.如果不可能,是否有更好的方法将我正在查找的数据 WHERE application LIKE isNull('%MORESTUFF%','%')
放入临时表中?
This seems to output my data currently the way that i need it to, but I would like to pass it into a Temp Table. My problem is that I am pretty new to SQL Queries and have not been able to find a way to do so. Or if it is even possible. If it is not possible, is there a better way to get the data that i am looking for WHERE application LIKE isNull('%MORESTUFF%','%')
into a temp table?
推荐答案
SELECT *
INTO #Temp
FROM
(SELECT
Received,
Total,
Answer,
(CASE WHEN application LIKE '%STUFF%' THEN 'MORESTUFF' END) AS application
FROM
FirstTable
WHERE
Recieved = 1 AND
application = 'MORESTUFF'
GROUP BY
CASE WHEN application LIKE '%STUFF%' THEN 'MORESTUFF' END) data
WHERE
application LIKE
isNull(
'%MORESTUFF%',
'%')
这篇关于使用查询将数据插入临时表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!