Found the answer to the first part of my question:
SELECT D_Num = IDENTITY(int, 1, 1),*
INTO temptable
FROM
someViewOrTable
Frank Flynn [EMAIL PROTECTED] wrote:
On 2/19/04 4:09 PM, [EMAIL PROTECTED]
wrote:
From: Karen Resplendo
Date: Thu, 19 Feb 2004 11:37:48 -0800 (PST)
To: [EMAIL
On 2/19/04 4:09 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Karen Resplendo [EMAIL PROTECTED]
Date: Thu, 19 Feb 2004 11:37:48 -0800 (PST)
To: [EMAIL PROTECTED]
Subject: Stored procedure with UNION---no unique id, how to page?
I have a stored procedure in msSQL that UNIONs 3