List:General Discussion« Previous MessageNext Message »
From:Girish Talluru Date:January 24 2013 6:41am
Subject:Stored procedure to update destination table from 3 source tables
View as plain text  
Hi All,

*project table*

proj_id, proj_name, Proj_Type

1, test, dev

2, test1, infra

3, test2, BI

*quota table*

quota_id, proj_id, allot_type, allot_num

1, 1, java, 3

2, 1, architect, 1

3, 1, Jasper, 2

4, 2, unix admin, 2

5, 2, dba, 1

6, 2, nwk admin, 1

*tracking table*

track_id, proj_id, status,start_date, sch_end_date,end_date, update_date

1,1, started,dec 16 2012,feb 12 2013,,01 jan 2013

2,2, resource allocated, 01 jan 2013, 03 mar 2013, , 01 jan 2013

3,3, yet to start, 19 jan 2013, 19 apr 2013

*Destination table (Summary_Table)*

event_id, proj_id, proj_name, Proj_Type, allot_type, allow_num,
proj_start_date_sch_end_date, proj_status

1, 1, test,dev,java,3,16 dec 2012,12 feb 2013,started

2, 1, test,dev,architect,1,16 dec 2012, 12 feb 2013, started

3, 1, test,dev,jasper, 2, 16 dec 2012, 12 feb 2013, started


I have to write a stored procedure to load the destination table with the
information from all three source tables

and another procedure to update the records regularly in destination table
when ever there is a change in source tables such as project status changed
from started to delivered etc.

Can some one give me some sample procedures to achieve above please.

Thanks,
Girish Talluru

Thread
Stored procedure to update destination table from 3 source tablesGirish Talluru24 Jan