sql - trying Insert data of tables into one temporary table and insert again into same temp table from a different table -

sql - trying Insert data of tables into one temporary table and insert again into same temp table from a different table -

February 15, 2011

trying insert data of tables 1 temporary table adn insert again same temp table different table

select

sfb.sap_ship_to,sfb.sap_sold_to,sfb.invoice_date,fb.material_group,sfb.fuel_group,sfb.interface_status,sfb.gross_flag,sfb.gross_qty, sfb.net_qty

into     #mda_temp_sap_fuel_bdocs   mda_agreement_site sas join     sap_fuel_bdocs sfb  on  sas.sap__c = sfb.sap_ship_to    sfb.interface_status = 'summed'/*

and

*/

-------------------------------------------step2

select       sfb.sap_ship_to,     sfb.sap_sold_to,     sfb.invoice_date,     sfb.material_group,     sfb.fuel_group,     sfb.interface_status,     sfb.gross_flag,     sfb.gross_qty,     sfb.net_qty  #mda_temp_sap_fuel_bdocs   mda_agreement_site sas  join     sap_fuel_bdocs_archive sfb  on   sas.sap__c = sfb.sap_ship_to    sfb.interface_status = 'summed'

Comments