Thanks a lot Luis/SSCrazy. Your solution worked like magic :w00t:

Hi dwain.c,

Thanks for the answer, your solution seems more accurate to me.

I will revert after checking the output.

Thanks a lot 🙂

Thanks for the reply SSC Eights!, however I require a different output.

The query you posted returns the number of childs of each user, instead I need the number of profiles...

Sorry for the trouble guys I should have posted the scripts earlier.

Here are the scripts for table creation and data population:

Create Table UserMast

(

UserID uniqueidentifier default newid(),

EmailID varchar(100),

ParentID uniqueidentifier,

)

Create Table ProfileMast

(

ProfileID...