lin_GetAquireSkill:
ALTER PROCEDURE [dbo].[lin_GetAquireSkill]
(
@char_id INT,
@subjob_id INT
)
AS
SET NOCOUNT ON
SELECT skill_id, skill_lev, is_lock FROM user_skill WHERE char_id = @char_id AND ISNULL(subjob_id, 0) = @subjob_id ORDER BY 1, 2
Edit it to:
ALTER PROCEDURE [dbo].[lin_GetAquireSkill]
(
@char_id INT,
@subjob_id INT
)
AS
SET NOCOUNT ON
SELECT skill_id, skill_lev, is_lock FROM user_skill WHERE char_id = @char_id ORDER BY 1, 2
Haven't tested but might work ;)