Declare @ServerName varchar(10);
Set @ServerName   = 'DDD-111'
Set @ServerName2  = @ServerName  --This is temp...until we get the new server up

--this gives me an error asking me to link to the server (although I'm in the server)
Select *
From [@ServerName].[Database].[dbo].[TableName]
Join 
[@ServerName2].[Database].[dbo].[TableName]

--However when I run it like this, it works fine
Select *
From [ServerName].[Database].[dbo].[TableName]
Join 
[ServerName].[Database].[dbo].[TableName]

Declare @ServerName varchar(10);
Set @ServerName   = 'DDD-111'
Set @ServerName2  = @ServerName  --This is temp...until we get the new server up

DECLARE @sql NVARCHAR(4000);
SET @sql = 
'Select *
From [@ServerName].[Database].[dbo].[TableName]
Join ' + QUOTENAME(@ServerName2) 
+'.[Database].[dbo].[TableName]';

EXEC(@sql);