My favourite bad comment is

"recreated it by using more functions instead of joins"

Followed by a nest of scalar functions and while loops. It happens to be one of the worst...