I decided to go with an inline function and pass the parameter to it. This is a new query but very similar.

Like this:

CREATE FUNCTION league_Team (@xID...

Thanks Grant

I didn't mention that I was working in vbscript so that was my mistake.

I must be missing something though because I am still not sure how we arrive...

SELECT l.leagueplayer,

l.ltID,

l.approved

FROM leagueplayers l

WHERE l.ltID= @xID

In this case is the @xID defined somewhere. I am using VB Script...