how would you do that?,

maybe a good idea!

Hi,

I just need 1 row,

but with that query i executed 2 times and give me 2 same..

i need not repeat the result..

I just Need 1 row.

The table have around 2000 records.

Yes a column with the name "id" is the identity.

I've been testing the above query but sometimes give 2 times return...

Thanks!

if there is a more efficient would it be?

Okay, sorry for that, i appreciate ur help.

Thanks dude, but i got a problem with ur example.

Check it:

DECLARE @tbl TABLE

(

ID INT, id_part INT, ord INT, lev int

)

INSERT INTO @tbl

SELECT 1606,1513852,183,2 UNION ALL

SELECT 1606,1513853,184,3 UNION ALL

SELECT 1606,1513854,185,2...