Database

SELECT EmpID, 
       [Date], 
       CASE Reason 
          WHEN 'Fi' THEN 'Fire'
          WHEN 'Rt' THEN 'Retired'
          ...
       END AS Reason
FROM dbo.tblEmpStop

DROP TABLE #Teste

DECLARE @x int
SET @x = 5

IF @x > 1
SELECT IDField1
INTO #Teste
FROM Table1

ELSE

SELECT IDField2
INTO #Teste
FROM Table1

(...)

DROP TABLE #Teste;
CREATE TABLE #Teste (
   IDField1 int
);
DECLARE @x int;
SET @x = 5;
IF (@x > 1)
BEGIN
   INSERT INTO #Teste
   SELECT IDField1
   FROM   Table1;
END;
ELSE 
BEGIN
   INSERT INTO #Teste
   SELECT IDField1
   FROM   Table1;
END;