>I narrowed it down to the Routes table being the problem. Once I remove that from the SP it works properly!
Change INNER JOIN to LEFT JOIN and see what happens.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.