title: Insert Into Select stored procedure not working inserting NULL
body: <p>My first time creating a stored procedure here please go easy on me. I was trying to <code>SELECT</code> my data from Table 1 (<code>EmpTBL</code>), then <code>INSERT</code> it into Table 2 (<code>EventTBL</code>) </p>
  
  <p>I think the culprit is this line right here: </p>
  
  <pre><code>@Ename varchar(250) = NULL, 
  @Edate varchar(250) = NULL,
  </code></pre>
  
  <p>I think my logic is in the right direction I just dont why it doesn't work. </p>
  
  <p>Not sure what to do next.</p>
  
  <pre><code>ALTER PROCEDURE spBdayEmp
     (@Ename varchar(250) = NUll,
      @Edate varchar(250)= NUll,
      @Etype varchar(250)  = 'Bday')
  AS 
      INSERT INTO EventTBL(EventName, EventDate, EventType)
      VALUES (@Ename, @Edate, @Etype)
  
      SELECT
          @Ename =  (Ename + ' ' + Lname),    
          @Edate =  DATEADD(YY, DATEPART(YYYY, GETDATE()) - DATEPART(YYYY,dateOfBirth), dateOfBirth) 
      FROM 
          EmpTBL   
      WHERE  
          DATEADD( Year, DATEPART( Year, GETDATE()) - DATEPART( Year, DateOfBirth), DateOfBirth) BETWEEN CONVERT( DATE, GETDATE()) AND CONVERT( DATE, GETDATE() + 30); 
  </code></pre>
  
  <p>how would i get the values for? @Ename, @Edate?</p>
  
  <p>i would like the result of the SELECT query "Ename + ' ' + Lname," equals to "@Ename" and " DATEADD(YY, DATEPART(YYYY, GETDATE()) - DATEPART(YYYY,dateOfBirth), dateOfBirth)," equals to "@Edate"?</p>