STORING IDENTITY VALUES

[sheryl kemp]

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.

[David Satz]

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.