got it!

reverse(right(reverse(app), len(app) - charindex('-',reverse(app),1)))

Can you provide an example? Since I am new to sql.

Can you provide an example, since I am new to sql.

Yeah that's fine, I'm clear now. So probably how about a stored procedure to perform Insert, Update and Delete operations. On some conditions they need to be queried, initially for...

Hi Sean,

Got it. I made changes to the table. I am not creating a stored procedure, instead I am trying to write two separate queries for Insert & Delete.

In...

Got it. Thanks a lot for helping guys.

So table design issue because of bringing the group values on top of CCSG Group?

Hi Sean,

I need to display values of Site Group, LOB Group, Sales group like we displayed for CCSG Group in the same query. May be a sub-query?

Mike logs in...

Hi Sean,

I am doing this for SSRS reports. I mean its like when user logs in as CCSG Group these group values should also show up(Site Group, Sales Group, LOB...

Hi Sean,

This is just fine. Now on top of this. I just want to display LOB Group, Site Group, Service Group for CCSG Group.

EX: If Mike log in, he belongs...

Hi Nevyn,

Site Group, Sales Group, LOB Group and CCSG Group are values present in BSP_LOB_GRP column.

If a user is logged in as a CCSG Group members he should also...