Thanks for that, I've found the errors and I wander if you could help me.

The first error was in the Preparation SQL task. This used a create table sql statement...

Sorry about the confusion,

I would like the query to return 1 row per departure airport, preferably the one with the cheapest price.

Thanks again

Any which the departure date is greater than todays date and WHERE City.name (when joined with the City table) LIKE 'B%'.

I limit the returned results to 20 as they are...

No problem Gail,

Hi Gail,

Unfortunatley the query I thought was working the way I wanted it seems to not pull out all the flights available to the various destinations for each departure airport....

Thanks for posting that, gives me the results that I want.

I've never used the sql snippet below before:

ROW_NUMBER() OVER PARTITION BY

so it's gave me something to look into as...

The two Stansteds are because they have different destinations. You want only 1 row per departure airport, regardless of where the flight is going?

Yes that would be great.

I think the...

No problem Gail,

Thanks

Hi Gail,

Many Thanks

It would probably be the one corresponding to the cheapest price, but it would be handy to know how to display any one at random also.

Thanks again

Hi Gail,

Many Thanks

ok thanks again for the help and advice Peso.

Thanks Jack also for advising on other solutions and methods of achieving this.

Cheers Mark 🙂

Thanks Peso,

the function works a treat!

I noticed the function Numeric(18,4) for returning the money value.

I understand (18,4) has to do with the decimal point.

Can I ask a...

Yes it is, the only thing I had to do was add distinct to the select statement and of course rearrange some of the columns.

Thanks again for your help

Thanks for your help John, the SQL statement does the insert in 12 seconds.

Good work! 😀