CREATE PROCEDURE QOTD (@source INT)
AS 
BEGIN
 DECLARE @strQueryDML AS VARCHAR(100)
 	
 IF @source = 1 
	SET @strQueryDML = 'SELECT ID INTO #tmpID2 FROM tbl1'
 ELSE
	 SET @strQueryDML = 'SELECT ID INTO #tmpID2 FROM tbl2'

 EXECUTE (@strQueryDML)
 
 SELECT ID FROM #tmpID2
  
END

DROP TABLE tbl1
DROP TABLE tbl2

IF 1 = 2
  BEGIN;
    DECLARE @a int;
  END;
SET @a = 1;
PRINT @a;

IF 1 = 2
  BEGIN;
    CREATE TABLE #xyz (a int)
  END;
INSERT INTO #xyz(a) VALUES(1);
SELECT * FROM #xyz;

CREATE PROCEDURE QOTD (@source INT)
AS 
BEGIN;
 CREATE TABLE #tmpID (ID int);
 IF @source = 1 
   INSERT INTO #tmpID (ID)
   SELECT ID FROM tbl1;
 ELSE
   INSERT INTO #tmpID (ID)
   SELECT ID FROM tbl2;

 SELECT ID FROM #tmpID;
END;

CREATE PROCEDURE QOTD (@source INT)
AS 
BEGIN;
 SELECT ID INTO #tmpID FROM tbl1 WHERE 1 = 2;
 IF @source = 1 
   INSERT INTO #tmpID (ID)
   SELECT ID FROM tbl1;
 ELSE
   INSERT INTO #tmpID (ID)
   SELECT ID FROM tbl2;

 SELECT ID FROM #tmpID;
END;