sau asa....dar tot intortochiat e.....mai sa-mi rup mainile si nu alta :)))

CREATE TABLE #temp (numar varchar(50), data_inreg datetime)

insert into #temp (numar, data_inreg)
  SELECT     nr_inreg Nr, MAX(data_inreg) AS Data
  FROM         dbo.Table2
  GROUP BY nr_inreg
  HAVING      (MAX(data_inreg) < CONVERT(DATETIME, '2007-07-26 00:00:00', 102))

select tbl.* from dbo.Table2 tbl join #temp t on tbl.nr_inreg = t.numar and tbl.data_inreg = t.data_inreg
where tbl.tip is null

drop table #temp