the udf is designed to get us the buyers names from the system and then we can only take the first 30 or the system goes boom. Some of these...

how do i make sure all the statistics are up up to date?

Here is the sqlplan and a PDF of the actual store procedure. like I said running each piece separate is fast and running them together without the union all is...