AnsweredAssumed Answered

convert sysbase to sql server 2102 ?

Question asked by srinivas srinivas on Sep 15, 2014
SELECT   gas_qlty_cylinder.cylinder_id,             gas_qlty_cylinder.qualification_date,             gas_qlty_cylinder.location_id,             gas_qlty_lab.lab_desc,             gas_qlty_cylinder.start_date,             gas_qlty_cylinder.end_date,             analysis_data.date_set,             analysis_data.date_removed,             analysis_data.btu,             analysis_data.spec_gvty,             gas_qlty_cylinder.remarks,             gas_qlty_cylinder.mcsusr_id,             gas_qlty_cylinder.trans_timestamp   FROM     gas_qlty_cylinder,             analysis_data ,            gas_qlty_location,             gas_qlty_lab   WHERE    ( gas_qlty_cylinder.cylinder_id *= analysis_data.cylinder_id ) and            ( gas_qlty_location.location_id = gas_qlty_cylinder.location_id ) and          ( gas_qlty_location.lab_id = gas_qlty_lab.lab_id ) and            ( analysis_data.analyzed_time =* ( select max(analyzed_time) from analysis_data      where gas_qlty_cylinder.cylinder_id = analysis_data.cylinder_id and     gas_qlty_cylinder.location_id = analysis_data.location_id ))    Order by cylinder_id

Outcomes