add sp_retrieve_route stored procedure