Instead of doing a count of records, just return 1 if what you want exists

Declare @DynamicSQl nvarchar(250),

@UserGroupId Int,

@x nvarchar(100)

select @x = '@retVal int output'

SET @DynamicSQl = 'select @retVal =...