title: Selecting a database from a variable
body: <p>So I have two databases that have no relationship between them. The first one is where my dbo.Clients exists and  has a column of the database name of the second db . My thought was to select the dbName from the Clients then use that variable to select data from the second database. 
  The query doesnt run can some one shed a little light? Thanks.</p>
  
  <pre><code>    @dbName varchar(50) OUTPUT,
  @clientID varchar(50)
  AS
  BEGIN
      SET NOCOUNT ON;
      -- Insert statements for procedure here
      SELECT * FROM sql02.iproconfig4.dbo.Clients 
      SET @dbName = (SELECT Clients.ClientDatabase FROM sql02.iproconfig4.dbo.Clients WHERE ClientID = @clientID) 
      SELECT * FROM sql02.@dbName.dbo.Discovery   
  END
  </code></pre>