primeiramente obrigado pela ajuda e o arquivo disponibilizado !
porem verifiquei a query e so tinha nesse lugar o ALTER
ALTER PROCEDURE [dbo].[WZ_GetCharacterGensInfo] , ai mudei para CREATE , porem deu os seguintes erros !
Msg 156, Level 15, State 1, Procedure fn_rank_gens, Line 22
Incorrect syntax near the keyword 'CREATE'.
Msg 134, Level 15, State 1, Procedure fn_rank_gens, Line 23
The variable name '@Name' has already been declared. Variable names must be unique within a query batch or stored procedure.
Msg 137, Level 15, State 2, Procedure fn_rank_gens, Line 31
Must declare the scalar variable "@Family".
Msg 156, Level 15, State 1, Procedure fn_rank_gens, Line 35
Incorrect syntax near the keyword 'ELSE'.