Hi Lynn,

Is it possible to sort the User_Group column in this query.

For Instance:User_Group column has values like this

Hi

Hey

Hey

Hi

Expected Output should be like this

Hi

Hi

Hey

Hey

DECLARE @CCSG varchar

DECLARE @user1 varchar

SET @CCSG = CASE WHEN EXISTS(SELECT 1

FROM USER_PRFL up

INNER JOIN BSP_LOB_Grp_Lookup bl

ON bl.BSP_LOB_GRP = up.User_Group

INNER JOIN IMPACTED_LOB il

ON il.BSP_LOB_CD = bl.BSP_LOB_CD

WHERE BSP_LOB_GRP = 'Sales Group'

AND up.User_Id='Russell'

)

THEN 1 ELSE 0 END

SELECT *

FROM USER_PRFL up

INNER JOIN BSP_LOB_Grp_Lookup bl

ON bl.BSP_LOB_GRP = up.User_Group

INNER JOIN IMPACTED_LOB il

ON il.BSP_LOB_CD = bl.BSP_LOB_CD

WHERE (up.User_Id='Russell' AND @CCSG = 0)

OR (BSP_LOB_GRP IN ('LOB Group','Site Group','Sales Group','CCSG Group') AND @CCSG = 1)