select distinct

Hi Radim,

Why don't you group it as per ltr_bar_code if it has got no duplicate values.

One way of whowing this is like the following

SELECT * FROM TempSent
WHERE id IN
(SELECT MIN(id) FROM TempSent GROUP BY ltr_bar_code)

This will select only one row for each distinct ltr_bar_code, the row with the minimum id which is what your result seems to portray


Another way

 WITH Distinctbarcode AS
(
    SELECT ID,ltr_bar_code,ltr_DBTRN,SMX_ID,
        ROW_NUMBER() OVER(PARTITION BY ltr_bar_code ORDER BY ID) AS 'RowNum'
    FROM TempSent)


SELECT *
FROM TempSent
WHERE RowNum = 1

[ col1,col2,col3 are the columns you want to display ]

This works on SQL Server 2005 onwards

Now you can use other columns as well to select the records

Keep me posted, hope this helps you,mark it as an answer if it has helped you