NON equijoins

Hi there.

I just wanted to see if anyone has come across any patterns to deal with NON equijoins.

Based on this article - http://sqljunkies.com/WebLog/tpagel/archive/2005/08/31/16585.aspx - there seems to be 2 approaches:

1) encapsulate the logic in a stored procedure or

2) generate a joined dataset with potentially alot of unwanted rows which then need to be filtered out.

Are there any other patterns people have discovered?

Thanks.

Hi,

I had the same issue we found the solution ourselves. Look at the third thread in this question

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=367775&SiteID=1

Basically you can modify the sql in Advanced tab. Hope this helps