CREATE PROCEDURE qry_investment_bond (@from_date as smalldatetime  ) AS

EXEC ('DELETE FROM dbo.tbl_tmp_investment')

INSERT INTO dbo.tbl_tmp_investment
                      (temp_ev_ccy, temp_ca_activ, temp_ca_astype, temp_ca_acct_no, temp_ca_asset, temp_ca_balance, temp_ca_bal_fx, temp_COUNTRY, temp_issuer, 
                      temp_issuer_type, temp_FLOATING, temp_BOND_PD_RA, temp_BOND_PD_ST, temp_BOND_PD_EN, temp_LI_PERIOD_, temp_LI_PERIOD2, 
                      temp_LI_PERIOD5, temp_MATURITY, temp_date, temp_date_flag)
SELECT     dbo.tbl_investment.EV_CCY, dbo.tbl_investment.CA_ACTIV, dbo.tbl_investment.CA_ASTYPE, dbo.tbl_investment.CA_ACCT_NO, 
                      dbo.tbl_investment.CA_ASSET, dbo.tbl_investment.CA_BALANCE, dbo.tbl_investment.CA_BAL_FX, dbo.asDump.COUNTRY, dbo.tbl_issuer.issuer, 
                      dbo.tbl_issuer.issuer_type, dbo.asDump.FLOATING, dbo.asDump.BOND_PD_RA, dbo.asDump.BOND_PD_ST, dbo.asDump.BOND_PD_EN, 
                      dbo.asDump.LI_PERIOD_, dbo.asDump.LI_PERIOD2, dbo.asDump.LI_PERIOD5, dbo.asDump.MATURITY,  
	          @from_date, @from_date > dbo.asDump.BOND_PD_ST And @from_date <= dbo.asDump.BOND_PD_EN
FROM         dbo.asDump INNER JOIN
                      dbo.tbl_investment ON dbo.asDump.ASSET = dbo.tbl_investment.CA_ASSET INNER JOIN
                      dbo.tbl_issuer ON dbo.asDump.ISSUER = dbo.tbl_issuer.issuer
WHERE     (dbo.tbl_investment.CA_ACTIV = 'TRD' OR
                      dbo.tbl_investment.CA_ACTIV = 'LPTRD' OR
                      dbo.tbl_investment.CA_ACTIV = 'NTRD' OR
                      dbo.tbl_investment.CA_ACTIV = 'ORG' OR
                      dbo.tbl_investment.CA_ACTIV = 'LPORG' OR
                      dbo.tbl_investment.CA_ACTIV = 'NORG' OR
                      dbo.tbl_investment.CA_ACTIV = 'AFS' OR
                      dbo.tbl_investment.CA_ACTIV = 'NAFS' OR
                      dbo.tbl_investment.CA_ACTIV = 'LPAFS') AND (dbo.tbl_investment.CA_ASTYPE = 'BOND')

	/* SET NOCOUNT ON */
	RETURN 


GO