title: How to declare a variable in SQL Server and use it in the same Stored Procedure
body: <p>Im trying to get the value from BrandID in one table and add it to another table. But I can't get it to work. Anybody know how to do it right?</p>
  
  <pre><code>CREATE PROCEDURE AddBrand
  AS
  
  DECLARE 
  @BrandName nvarchar(50),
  @CategoryID int,
  @BrandID int
  
  SELECT @BrandID = BrandID FROM tblBrand 
  WHERE BrandName = @BrandName
  
  INSERT INTO tblBrandinCategory (CategoryID, BrandID) 
         VALUES (@CategoryID, @BrandID) 
  
  RETURN
  </code></pre>