How do I convert the following Sql script so that it will run on Sql Server 2000 (which does not support the OUTPUT feature?
--Create new locations and capture Location Name and new LocationIDs, AreaIDs in temp table _NewLocationis
INSERT INTO Locations ( [LocationName], [LocationOrder], [LocationNotes], [AreaID], [NumberInArea] )
--Add new inserted Locations into temp table _NewLocations
OUTPUT INSERTED.LocationID, INSERTED.LocationName, INSERTED.AreaID INTO _NewLocations (LocationID, LocationName,AreaID)
SELECT LocationName, LocationOrder, LocationNotes, @NewAreaID, NumberInArea
ORDER BY LocationID