I know I can create a temporary table using a SP like this:
CREATE TABLE #mytemptable (A int null, B int null, C int null)
INSERT INTO #mytemptable
EXEC mystoredprocedure @oneparameter, @anotherparameter;
Can I avoid creating a full table (and possibly an insanely long) CREATE TABLE somehow by taking only the field A? T-SQL doesn't seem to like back-to-back FROM and EXEC which creates this problem for me.