Hi,

I would approach this by having a single server DB and set up an ETL process which removes the ID conflicts as the data is loaded into the central DB.

HTH

Mat

Hi,

Also some companies operate a Saturday as a normal business day. Again probably needs to be specified in the SLA however it may affect the calculations as well.

Mat

Hi,

Not sure if this has been discussed but you could write a query that counts the number of weekend days and hollidays between the the two dates and based on...

Hi,

One other potential variation to this would be that different companies observe different hollidays based on the industry they are in eg. Easter where some close both days and others...