BambooHR Interview Question

Thoughts on stored procedures, pros/cons etc