Apparently, I can't use them. I'm getting an error message like:
Invalid use of a side-effecting operator 'SELECT' within a function
If I want to do something like this:
select bleh
into #temp
from Blah
... inside a function.
No, per this thread where the same question was asked, you cannot, but you can use a table variable
DECLARE @MyTempTableVariable TABLE (SCHEMA)
INSERT INTO @MyTempTableVariable
SELECT bleh
FROM bleh