I am trying to parameterize some dynamic sql where the table name is what can change
SET @dynSQL = N'SELECT @Stu_Award_Year_Out = MAX(stu_award_year_token) FROM [PF].['+@Prefix + @DBNAME+'].[dbo].[stu_year]'
I can't figure out how to write the above statement so I can pass the variables in through the statement below
SET @ParamDefinition = N'
    @dbName NVARCHAR(10),
    @Prefix NVARCHAR(10),
    @Stu_Award_Year_OUT INT OUTPUT'
EXECUTE sys.sp_executesql
        @dynSQL,
        @ParamDefinition,
        @Prefix,
        @dbname,
        @stu_award_year_OUT = @stu_award_year_count OUTPUT 
Any help would be greatly appreciated!!!
