kragness rolled up all prep queries into one stored procedure