SELECT
	a.c_id
	, a.u_id
	, a.visit_date
	, [last_trans] = MAX(t.trans_date)
FROM #AddLastTrans a
LEFT JOIN Trans t
	ON a.c_id = t.c_id
	AND a.u_id = t.u_id
	AND a.visit_date >= t.trans_date
GROUP BY
	a.c_id
	, a.u_id
	, a.visit_date

create table #tmp(id int);
insert into #tmp values (1);
insert into #tmp values (null);
insert into #tmp values (2);
select max(id) from #tmp;
drop table #tmp

quote:

---

Originally posted by sunitabeck

It is a message that means just what it says - that some null values were eliminated when doing the aggregate function. For example if you run this code, you will get the same message:

create table #tmp(id int);
insert into #tmp values (1);
insert into #tmp values (null);
insert into #tmp values (2);
select max(id) from #tmp;
drop table #tmp

---