One other important note,

We do not have enterprise edition, thus I do not think we can use peer to peer.

Both locations can update the data, however, by application design, they cannot update the same report at the same time. If a report is open, I do not allow...

You will need to use dynamic sql and the getDate() function.

This should get you started...

@TABLE_NAME VARCHAR(50),

@sql VARCHAR(MAX),

Set @TABLE_NAME = CONVERT(VarChar(20), GETDATE(), 101)

/* Generate table */

SET @sql...

Ok, The adjustments are used to calculate a final forecast price of a drug.

Formula is something like

DrugPrice * TreatedDays * Compliance * PatientShare = ForecastSalesPrice for a givendrug

Definitions of ajustments

TreatedDays...