USE [UDJTC]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Proc [dbo].[usp_GetFeaturedMemberDetailPi]
AS
with a as
(
select *, CHARINDEX('/', Reg_No)+1 c from LM_commiteemember
), b as
(
select *, CHARINDEX('/', Reg_No, c)-1 d from a
)
, d as
(
select * , SUBSTRING(Reg_No, 1, c-2) f, cast(SUBSTRING(Reg_No, c, d-c+1) as int) e from b
)
select * from d order by f, e