Thanks all for your help, had to tweak it a little but works great.

Hi Thanks for the reply, here is a script that build and populates the tables

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Schedule](

[OrderID] [int] NOT NULL,

[Start] [datetime] NOT NULL,

[End] [datetime] NOT NULL

)...

Fantastic guys thanks for that, plently for me to play with. Suppose I want to track the results over time, what are you thoughts on dumping the results into a...

think I may have something

SELECT co1.productID, co1.supplierID, co1.price, co1.basesupplierID

FROM test1 AS co1,

(SELECT productID, MIN(price) AS minPrice

...

Hi, thanks for the quick response. Its not a homework question (I'm 30+ 🙂 ) and I've been lumbered with this from work.

This is some create/insert code:

CREATE TABLE [dbo].[test1](

[BaseSupplierID]...