-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: SriSamp
Message 4 in Discussion
Here is a simplified implementation: DECLARE @fname VARCHAR(10)
DECLARE @lname VARCHAR(10)
DECLARE @id INT
BEGIN
SELECT @fname = NULL, @lname = NULL, @id = NULL SELECT
a.[id], a.fname, a.lname, a.address,
maxVisitID = ISNULL ((SELECT MAX(b.visitID) FROM tableB b WHERE b.[id] =
a.[id]), 0)
FROM
tableA a
WHERE
a.fname LIKE CASE WHEN @fname IS NULL THEN '%' ELSE @fname + '%' END AND
a.lname LIKE CASE WHEN @lname IS NULL THEN '%' ELSE @lname + '%' END AND
a.[id] = CASE WHEN @id IS NULL THEN a.id ELSE @id END
END
Play around with the 3 variables @fname, @lname, @id to see if the results that you
get are what you want. HTH, Srinivas Sampath MVP - SQL Server
http://www32.brinkster.com/srisamp
-----------------------------------------------------------
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]
