I ran it again and got the following:

Msg 8117, Level 16, State 1, Line 1

Operand data type nvarchar is invalid for minus operator.

seems its data type related

Am still getting the same error message:

Msg 4145, Level 15, State 1, Line 5

An expression of non-boolean type specified in a context where a condition is expected, near 'ELSE'.

Msg 156,...

Got IT at last.

The subquery was far morw efficient than the Join, got more results than expected and there was no duplicate. Oooooooowwwwwwwweeeeeeeeeee!!!!!!!!!!

Am not very good with subqueries, thats why i tend to avoid it, is there a way you can guide me through?

The T_Items.AvailableLev <= 0 is the field within the table that informs end users of the available stock level “(back orders”- items where there is no stock available for shipping)

I...

These are the primary keys for the tables, and there are no constraints (sounds strange but thats they its set up)

T_OrderHeader - (PK, int, OrderID)

T_Payments -(PK, int, OrderID)

T_OrderLine -...

Thats right

Payments belong to a single order, with an Order having one or may stockIDs

Is it possible to have the for each loop container package to work on remote machines and servers?

It may sound stupid for an expert like you guys but would it be possible to list a step by step guuide on how to do this?

Hello All

I used the following query eventuallu without the DISTINCT keyword and it worked just fine:

SELECT CONVERT (NVARCHAR (20),T_OrderHeader.OrderDate,106) AS OrderDate, T_OrderHeader.OrderID, T_OrderHeader.CustomerID, T_OrderHeader.ShipTitle, T_OrderHeader.ShipForename,

...

I used the following query:

SELECT DISTINCT T_OrderHeader.OrderDate, T_OrderHeader.OrderID, T_OrderHeader.CustomerID, T_OrderHeader.ShipTitle, T_OrderHeader.ShipForename,

...

Thats right!!!

But how will it returns the list of countries not in the top 5 list?

Hello Lyn

Is there a way i can group the remaining countries as 'Others', so my end results will be the top and 5 and other countries?

Arghh, I see where I went wrong now!!!

Thanks for the guide