"debug queries" yea, that's the point where things start getting exciting when you have logic in queries that you actually have to debug. I too love 200 LoC (

"debug queries" yea, that's the point where things start getting exciting when you have logic in queries that you actually have to debug. I too love 200 LoC (tiny, in fact) procedures that inside build ""dynamic SQL"" aka string concat and EXEC with many OUTPUT parameters 10/10 experience, would recommend it to everyone. No, I don't want to debug my queries because it means that I'm probably doing too much on the database. I treat database more like a fancy data storage with outdated language, not as a business logic layer.