-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: BalajiKrishnan
Message 1 in Discussion
Table : A ID FName Lanme Address City 1 ARUN KUMAR X X 2 SHIVA
KUMAR Y Y 3 RAJ SEKAR Z Z Table : B ID VisitID Date 1 1 1/10/2002
2 1 12/11/2001 1 2 1/11/2003 1 3 1/12/2003
My requiremnt is I need to display ID,FName,LName,Address,max(visitid) .
ID FNAME LNAME ADDRESS MAXVISITID 1 ARUN KUMAR X 3
For this use a stored procedure which accepts three parameters
FNAME,LNAME,ID.
We can pass values to any one of the parameters and others will be null or we can pass
all the three to get the result.
I tried it is not working.
how can i do this.
Balaji.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
