Making subdivision on Procedure

• raghuldrag

  Hall of Fame

  Points: 3160

  More actions

  August 25, 2012 at 1:58 am

  #260996

  create table data_dd(slno numeric(22),goals varchar(22),kpi varchar(22),weightage numeric(22),record_status char(8),empcode varchar(12),accyear date)

  insert into(1,'webdevelopment',2451,40,u,002244,'2011-2012')

  insert into(6,'webdevelopment',2451,46,u,002244,'2011-2012')

  insert into(8,'webdevelopment',2451,46,u,001244,'2011-2012')

  insert into(9,'webdevelopment',2451,46,u,001244,'2011-2012')

  create tabledata_ddlhistory( slno numeric(12),goals varchar(22),kpi varchar(12),date_of_commitment date,weightage numeric(12),goals_review_date date ,status char(22),reviewcomments varchar(22),reviewdate date,reviewedby varchar(22)

  insert into(1,'web development',2451,'03-03-2011',45,'03-03-2011','u','perfect','1155')

  in above two tables first tables is goals entry of employee and 2nd table is golas history reviewed by his boss

  now expecting out is:

  goals columns if he ve history means

  >>>>>>>>>> goals history comes like sub division

  I am done procedure both tables separately...... now i ve doubt if employee ve history means how to display goals sub division of history in output

• rVadim

  Hall of Fame

  Points: 3969

  More actions

  August 25, 2012 at 2:22 am

  #1530043

  Your SQL is full of errors. Please fix and post correct statements.

  --Vadim R.