Thanks Chris.

Never thought of using LIKE in the join. I think your method would be a little more efficient too.

--Lenard

Well, after going for a nice long freezing walk, I figured it out:

WHERE

EXISTS ( SELECT * FROM @nameParts WHERE Person.FirstName LIKE strval )

...

Thanks Kathi. 

That is actually what I did after posting the message.  Also, because that snippet actually lives in a WHERE clause (I do an EXISTS on it), I also process...

Grasshopper,

What is wrong with displaying the "TOP 1" in a GROUP BY? In my case, an Event could be linked to multiple "event days".  I didn't want to show...

Got it sorted out with this article:

http://www.sqlservercentral.com/columnists/sjones/findfirst.asp

--Lenard

That would get around it for this simple example.  But in my "real world" senario, I have columns which return text based info (like location and incident text) and would fall apart there. 

Hi Antares686:

Actually, the ID will always be unique.  So changing your dataset slightly:

1, 001, 3, 20040301, 20040302

2, 002, 7, 20040501, 20040502

3, 002, 6, 20040503, 20040504

4, 002, 7, 20040505, 20040506

5, 001,...

Thanks wz700 for your reply.

Your method won't work in my "real world senario" because some of the columns in my SELECT statement may not contain the same value within the group.  I can...

Thanks for the code ALZDBA.  I will give it a whirl shortly. 

--Lenard

Jonathan,

I saw your reply to me on the Topic "help with stored procedure".

Thanks again.

--Lenard

Edited by - lenardd on 10/18/2003 5:18:36 PM

Ohhhhh, said the blind man and he picked up his hammer and saw.

I get it now.....thanks!

--Lenard

Jonathan, regarding your last statement.....

>> This is also incorrect, as it will return rows with NULL values even when the

>> arameter is not null. That's why I was confused on...

Hi Jonathon,

Thanks for your post. Regarding your code:

WHERE (AreaDesignatorID = ISNULL(@areaDesignatorID, AreaDesignatorID) OR ISNULL(AreaDesignatorID, @areaDesignatorID) IS NULL)

Why use 2 ISNULLs when