Use a stored procedure

-----Original Message-----
From: Niall Hannon (ext. 772) [mailto:Niall.Hannon@f...]
Sent: Friday, February 22, 2002 6:05 AM
To: sql language
Subject: [sql_language] Query



Hi,

What is the best way to create a parameter query in SQL 7.0. I am
developing a Crystal Report which reports on events between 2 dates. I
want the user to enter the two dates somewhere along the line which will
be used in the query, probably just after trying to run the report. Any
idea?

Thanks

Niall


************************************************************************
**
The information contained in this e-mail is confidential,
may be privileged and is intended only for the use of the recipient
named above. If you are not the intended recipient or a representative
of the intended recipient, you have received this e-mail in error and
must not copy, use or disclose the contents of this email to anybody
else. If you have received this e-mail in error, please notify the
sender immediately by return e-mail and permanently delete the copy you
received. This email has been swept for computer viruses. However, you
should carry out your own virus checks.


Registered in Ireland, No. 205721. http://www.FINEOS.com
************************************************************************
**


$subst('Email.Unsub').