-
STORING IDENTITY VALUES
How can I store identity values from 4 different tables and insert them into
one table. Each tables receive about 50 new rows of data each day and I
need to capture the identity value from each. Please help.
-
Re: STORING IDENTITY VALUES
create an INSERT trigger on all 4 tables...
--
HTH,
David Satz
Principal Web Engineer
Hyperion Solutions
{ SQL Server 2000 SP2/6.5 SP5a } { Cold Fusion 5 SP1 } { VSS }
(Please reply to group only - emails answered rarely)
-----------------------------------------------------------------
"sheryl kemp" <dianedinero@aol.com> wrote in message
news:3c973bb4$1@10.1.10.29...
>
> How can I store identity values from 4 different tables and insert them
into
> one table. Each tables receive about 50 new rows of data each day and I
> need to capture the identity value from each. Please help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|