C / C++ / MFC

//vSource is the the query below
//vConnection is a active open connection
//eCursorType = adOpenStatis
//eLockType = adLockOptimistic
//eOption = adCmdText.  I tried combining this with adExecuteRecord using 
//                      Bit OR with an error.  Bit AND caused no errors
//                      but also returned a closed recordset
pRst->raw_Open(vSource, vConnection, eCursorType, eLockType, lOptions);

DECLARE @Id bigint 
SET @Id = 2539
if OBJECT_ID('tempdb..#dumpTable','local') IS NOT NULL
	BEGIN 
		DROP TABLE #dumpTable
	END
	
CREATE TABLE #dumpTable
(
	Depth bigint,
	Parent bigint,
	Type bigint,
	ID bigint,
	Name nvarchar(80)
)
BEGIN
  --SOME WORK
  SELECT * FROM #DumpTable

  DROP TABLE #DumpTable
END