OK. I have taken your comments on board, I simplified the SQL I was using to make it more readable. The real procedures look like this:

ALTER FUNCTION [dbo].[fn_GetTopMatch](@LoginID AS int)

...

Thank you GSquared. I actually ended up with a very similar solution to yours.

First I defined a function:

create FUNCTION [dbo].[fn_GetTopMatch1](@LoginID AS int)

RETURNS TABLE

AS

RETURN

--

SELECT TOP...

Brandie Tarvin (11/22/2011)

---

You do realize that your rudeness and impatience has just branded you as someone that none of the regulars will ever want to help, right?

In fact, that second...

Come on you useless bunch of bum bandits. Answer the freaking question.