select into #temptable

4.97K viewsDataLink
0

in a custom sql statement can a select into a temp table be used and if so what is the syntax

0

SELECT donation_amount
INTO [#DONATIONS_TEMP]
FROM [Donations_&_Others] AS [Donations_&_Others]
where condition1

select * from [#DONATIONS_TEMP] where condition2

the second select would run against a smaller data set.

I think this should be in a future release.

You are viewing 1 out of 4 answers, click here to view all answers.

Latest Questions

Qloud Losing Formatting 4 Answers | 0 Votes
Meditation on timelines 3 Answers | 0 Votes