spGetProfilePhotoCategories

        CREATE Procedure dbo.spGetProfilePhotoCategories
        (
            @ClientsID int
        )
        AS
            select distinct Category 
            FROM dbo.ClientUsers INNER JOIN    dbo.ClientUserImages 
            ON dbo.ClientUsers.ID = dbo.ClientUserImages.ClientUsersID
            where ClientsID = @ClientsID
            order by Category