>Well then, how much data are you talking about in the cursor? You'll basically need to pass that data up to the server (via a SP) and then do the join there and return the result set. There is an OPENXML option in the FROM clause, so you could convert your cursor to XML and pass the string as a parameter to a SP for the JOIN to happen there.
The cursor is 500 IDs. It is really small. It is just a cursor for the primary keys. Then, I can use that to collect all the related fields from the table.
Could you provide an example on how I could accomplish that?