I have a stored procedure in msSQL that UNIONs 3 queries. There is no unique
identifier that is sequential that I can use to page on webpage because the data comes
from different tables/databases.
Is there a way to save the resultset into a temp table and add an
@@Identity(autonumber) to it?
Karen Resplendo wrote:
I have a stored procedure in msSQL that UNIONs 3 queries.
There is no unique identifier that is sequential that I can
use to page on webpage because the data comes from different
tables/databases.
Would you be able to use mssql_data_seek() to jump to the result set row