I have one table which is EquipmentCostVersion which contains the period wise cost for equipment. You can see the table structure here.
My requirement is , Lets assume that equipment WT0110 is assigned for one agreement which start from 02/01/2011 to 10/30/2012.
When im segregate the data by giving equipId, FromDate and ToDate the value should be stored in WorkActivity Table as per the Period Wise from EquipmentCostVersion table… The Result should be shown like as below …
Please share your Logic how to do by simple SQL Statement