I am always willing to learn new method or idea. I think I am come to realization that how difficult to assign lanes.

Is it possible to create a grid ...

Creating a round robin scoring grid is tougher than I thought...

I simplified the stored procedure and it works now.

Thank you all for your help.

Changed to:

@MinWeight money = Null,

@MaxWeight money = Null,

and Print

Select Distinct zc.Distance

,tUsr.*

,tAdd.*

,tEx.*

,tPh.*

From tbl_Address tAdd with (nolock)

Join #tmpZipCode zc

On tAdd.AddressZipCode = zc.ZipCode

Join tbl_Users tUsr with (nolock)

On...

so this is a SQL limitation?

Hello,

Thank you for your help.

Select Distinct zc.Distance

,tUsr.*

,tAdd.*

,tEx.*

,tPh.*

From tbl_Address tAdd with (nolock)

Join #tmpZipCode zc

On tAdd.AddressZipCode = zc.ZipCode

Join tbl_Users tUsr with (nolock)

On tUsr.UserID...

Sorry I cut & pasted wrong

USE [DBCrew]

GO

/****** Object: StoredProcedure [dbo].[spSearchCrew] Script Date: 02/18/2010 09:02:46 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[spSearchCrew] (

@ZipStart char(5),

@Distance int...

Hello Thank you for the reply.

USE [DBCrew]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

alter PROCEDURE dbo.SearchCrewAdvanced

(

@ZipStart char(5) = Null,

@Distance int = 10,

@PositionID int = Null,

@MinWeight varchar(50) = Null,

@MaxWeight varchar(50) = Null,

@EventID int =...