use left joins in Grants answer, eg

SELECT i.ItemNo_, i.ItemDescription, COALESECE(a.Description,b.Description,'')

FROM Item i

LEFT JOIN ItemExtraDescription a ON a.No_ = i.No_ AND a.LanguageCode = ''

LEFT JOIN ItemExtraDescription b ON...

Easy to forget that one doh!

...see alternative solutions posted by others, often yourself, which are often better than my original solution...

Especially with Jeff's...

1. Extract one row for each combination of unique columns (3) to another table

2. Truncate original table

3. Insert data (1) back into original table

Between works quite well

Especially if bigints

Kendall,

Hippo Birdy !!!

Add -b parameter to the isql command line

p.s. also check the use of the -m errorlevel parameter as well

In addition

Add an IDENTITY column (I'm sure I'll get flamed for this ) so that data can be tracked in insertion order (if required),...

Why is this done

Personal preference.

What is...

include the header in copy or save

Not possible to include headers in copy or save for Grid results...

Set output to text and tab format*, execute query, copy and paste results.

* Done in Tools, Options

M("BASE_" + unit_b) is retrieving by name, make sure unit_b is one of K, KG, MTR or ST

M(unit_a) is retrieving by ordinal number, your query has a maximum of 9 columns, make sure...

Use the duedate in the query and in the datagrid ItemDataBound event change the output value accordingly.