jesper (not addict :rolleyes... as my 'label' implies, i'm really a newbie here... first time posting

ok. lets...

hi addict, sorry for the late reply.

i'm thinking also to add a routing table to store the possible routing from origin to dest.

so i hv to search this routing table...

enthusiast,

u r right.

The stored proc would be something like:

CREATE PROCEDURE GetFreight

  @origin char(5),

  @destination char(5),

  @cntr_type char(4)

AS

  ...

Result returns based on the parameters, example

EXEC GetFreight...

anybody can help?