[Interlude] Subclass acumulativa Ajuda Pleasee

[dae]

Preciso de ajuda com o sistema cumulativo subclasse que estou usando,

nesesito que substitua a "skill" que são iguais

[Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

USE [lin2world]
GO
/****** Objeto: StoredProcedure [dbo].[lin_GetAquireSkill] Fecha de la secuencia de comandos: 02/23/2011 17:05:28 ******/
/********************************************
StuckSub

change
********************************************/

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[lin_GetAquireSkill]
(
@char_id INT,
@subjob_id INT
)
AS
SET NOCOUNT ON

/****** Objeto:SELECT skill_id, skill_lev, to_end_time FROM user_skill WHERE char_id = @char_id AND ISNULL(subjob_id, 0) = @subjob_id ORDER BY 1, 2******/

SELECT skill_id, MAX(skill_lev) as skill_lev, MAX(to_end_time) AS to_end_time FROM user_skill WHERE char_id = @char_id GROUP BY skill_id ORDER BY 1, 2

obrigado