sp_GetFullNameFromTable.sql

CREATE PROCEDURE dbo.sp_GetFullNameFromTable
		@ParmTableName varchar(100),
		@ParmUserName varchar(100)
AS
BEGIN
	DECLARE @FullQuery nvarchar(1000)
	SET @FullQuery = N'SELECT FullName FROM dbo.@TableName WHERE UserName = @UserName'

	DECLARE @ParmDefinition nvarchar(100) = N'@TableName varchar(100), @UserName varchar(100)';  

	EXEC sp_executesql @FullQuery, @ParmDefinition,  
					  @UserName = @ParmUserName,
					  @TableName = @ParmTableName;  

END