Why does BPCheckNestedLoopInCode raise a warning?

Question

Accepted Answer

This rule triggers when a while select loop is nested inside another loop, which causes serious performance degradation.
Fix: Replace nested loops with joined select statements or set-based operations.

Why does BPCheckNestedLoopInCode raise a warning?

Answer with Explanation