I have been playing with split function but was not able to use it for fields directly from select command.

I have solved the problem by creating a new table which contains the id of related table and record for each id of main table. updated it in the trigger.

But...

It would be very helpful if you point me to the exact link.

Rajesh

50-100 GB would be correct slot

These are thing we have to decide as this is still in primary stage and we can still constrain the user for now like

1. Updation of specific data on...

This is related to newly created municipal corp. data gathering project.

The municipal corp. is created from 3 small towns and so there are 3 centers for data collection.

But in...