Unique Records

Refer this,

declare  @temp table (Date datetime, [User] varchar(10),Place1 char(3) , Place2 char(3))
insert into @temp values ('2014/01/13','AACVQM','BOM','BRU')
insert into @temp values ('2014/01/13','AACVQM','BOM','BRU')
insert into @temp values ('2014/01/13','AACVQM','BOM','BRU')
insert into @temp values ('2014/01/13','AACVQM','BOM','BRU')
insert into @temp values ('2014/01/13','AACVQM','EWR','BRU')
insert into @temp values ('2014/01/13','AACVQM','EWR','BRU')
insert into @temp values ('2014/01/13','AACVQM','EWR','BRU')
insert into @temp values ('2014/01/13','AACVQM','EWR','BRU')
insert into @temp values ('2014/01/13','AACVQM','BRU','EWR')
insert into @temp values ('2014/01/13','AACVQM','BRU','EWR')
insert into @temp values ('2014/01/13','AACVQM','BRU','EWR')
select Date, [User],Place1 , place2 from (
select *,row_number() over (partition by Place1,[user],Place2,Date order by Place1,[user],Place2,Date) rn from @temp
) x
where rn = 1

---

Regards, RSingh