MSSQL Load Balance Control

We are currently working on a design for a MSSQL server farm that will consist of X number of MSSQL severs; each will serve as a processing engine using data each server stores locally. The results from the processed data will not be shared with the other servers in the farm.

The issue we are trying to resolve is if we can have the LTM appliance either through an external database call or internally stored key table preform a lookup on a string key (roughly 75 characters) which would be passed as part of the SQL call, and return which if any of the MSSQL servers have already performed the task and direct the call to the MSSQL server in the pool that already did the work previously.