what error?

declare @mypath varchar(50), @sql nvarchar(100)

set @mypath = 'myserver.mydatabase.dbo.'

set @sql = 'select * from ' + @mypath + 'order'

sp_executesql @sql