Query Hang up
Posted by:
Pravin K
Date: November 27, 2007 12:57AM
Query Hang up------------
Record Is 50 lacs. Pls Adcvise me
(SELECT Obligation_Action_Date, Starting_Date, Ending_Date, fedmine_id, EIN, DUNS, Recipient_Name, Recipient_City_Name, State_Name, Recipient_County_Name, Recipient_Zip_Code, Fiscal_Year_and_Quarter_Correction, Correction_Late_Indicator, Obligation_Action_Date, Type_of_Assistance_Transaction, Federal_Agency_Unit_Code, Federal_Agency_Name, CFDA_Program_Number, '03' as tblName, Total_Funding_Amount as amount FROM faads.03 T_1 WHERE 1 AND fedmine_id <> '') UNION (SELECT Obligation_Action_Date, Starting_Date, Ending_Date, fedmine_id, EIN, DUNS, Recipient_Name, Recipient_City_Name, State_Name, Recipient_County_Name, Recipient_Zip_Code, Fiscal_Year_and_Quarter_Correction, Correction_Late_Indicator, Obligation_Action_Date, Type_of_Assistance_Transaction, Federal_Agency_Unit_Code, Federal_Agency_Name, CFDA_Program_Number, '04' as tblName, Total_Funding_Amount as amount FROM faads.04 T_2 WHERE 1 AND fedmine_id <> '') UNION (SELECT Obligation_Action_Date, Starting_Date, Ending_Date, fedmine_id, EIN, DUNS, Recipient_Name, Recipient_City_Name, State_Name, Recipient_County_Name, Recipient_Zip_Code, Fiscal_Year_and_Quarter_Correction, Correction_Late_Indicator, Obligation_Action_Date, Type_of_Assistance_Transaction, Federal_Agency_Unit_Code, Federal_Agency_Name, CFDA_Program_Number, '05' as tblName, Total_Funding_Amount as amount FROM faads.05 T_3 WHERE 1 AND fedmine_id <> '') UNION (SELECT Obligation_Action_Date, Starting_Date, Ending_Date, fedmine_id, EIN, DUNS, Recipient_Name, Recipient_City_Name, State_Name, Recipient_County_Name, Recipient_Zip_Code, Fiscal_Year_and_Quarter_Correction, Correction_Late_Indicator, Obligation_Action_Date, Type_of_Assistance_Transaction, Federal_Agency_Unit_Code, Federal_Agency_Name, CFDA_Program_Number, '06' as tblName, Total_Funding_Amount as amount FROM faads.06 T_4 WHERE 1 AND fedmine_id <> '') order by fedmine_id asc, tblName DESC, Federal_Agency_Unit_Code ASC