Cursor vrs Temp Tables

From: runstein <runstein_at_biotronik.com>
Date: Thu, 21 Mar 2002 08:04:41 -0800
Message-ID: <u9k02n4r40jbc1_at_corp.supernews.com>

I know of two techniques for iterating through a resultset. One being a cursor, the other is creating a temp table and looping through the records.

Does anyone know which technique is more efficient? Are there situations where one is clearly better (or worse) than the other?

Thanks in advance Received on Thu Mar 21 2002 - 17:04:41 CET