Hey Kevin,
Try this: <CFSET "d#dept_num#_result" = value_returned_from_query>
Also, please tell Linda that my friend just replied to me and asked if you had all the service packs for the sql server. He said the server might be pulling the results from memory and the service packs addressed a number of memory related problems.
Take care,
GJ