pass parameters from ms access form to SPROC

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

pass parameters from ms access form to SPROC

Author

Topic

solent
Starting Member

33 Posts

Posted - 2005-11-03 : 09:58:40

i have this SPROC and i would like to pass the from_date a value from an text box inside an ms access form in an adp. any idea how i can do that.

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)
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         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
GROUP BY 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.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, dbo.asDump.FLOATING
HAVING      (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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources