Hello, Steve Thank You for your kindness.

I made some minor changes in the code you have posted which suits my requirement, its working fine.

SELECT
  AC.activityName,
  AC.activityCode,
  ISNULL(OPO.operatorName, '') AS Operator,
  ASP3.orderNumber,
  STUFF((SELECT DISTINCT ', ' + O.operatorName
  FROM @Operators AS O
   INNER JOIN @ActivitiesPositions AS AP
    ON O.operatorIncId = AP.operatorIncId
    AND O.operatorSqlId = AP.operatorSqlId AND O.isDeleted = 0 AND AP.isDeleted = 0
    AND AP.activityIncId = ASP3.activityIncId
    AND AP.activitySqlId = ASP3.activitySqlId
    AND AP.orderNumber>ASP3.orderNumber
    INNER JOIN @Positions AS POS ON POS.positionIncId = AP.positionIncId AND POS.positionSqlId = AP.positionSqlId AND POS.positionCode = 'EAS006' --Operator
  FOR XML PATH('')
  ), 1, 2, '') AS OtherOperators
FROM @Activities AS AC
  LEFT JOIN @ActivitiesPositions AS ASP3
   ON AC.activityIncId = ASP3.activityIncId
   AND AC.activitySqlId = ASP3.activitySqlId
   AND ASP3.isDeleted = 0x0
  LEFT JOIN @Operators AS OPO
   ON OPO.operatorIncId = ASP3.operatorIncId
   AND OPO.operatorSqlId = ASP3.operatorSqlId
   AND OPO.isDeleted = 0x0
  INNER JOIN @Positions AS POS6
   ON POS6.positionIncId = ASP3.positionIncId AND POS6.positionSqlId = ASP3.positionSqlId
   AND POS6.positionCode = 'EAS006' --Operator
   AND ASP3.orderNumber = (
    SELECT TOP 1 orderNumber
    FROM @ActivitiesPositions AS ActPos2
      INNER JOIN @Positions AS Pos2
       ON ActPos2.activityIncId = ASP3.activityIncId
       AND ActPos2.activitySqlId = ASP3.activitySqlId
       AND ActPos2.positionIncId = Pos2.positionIncId
       AND ActPos2.positionSqlId = Pos2.positionSqlId
       AND Pos2.positionCode = 'EAS006'
       AND ActPos2.isDeleted = 0x0
       AND Pos2.isDeleted = 0x0
    ORDER BY orderNumber ASC
    )
ORDER BY AC.activityCode;