We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
create table #test ( descr varchar(3), processDate datetime, shipId as varchar(4) ) insert into #test ('a1','2011-02-13 16:57:22.080','1111') --same date for a1 insert into #test ('a1','2011-02-13 16:57:22.080','2222') --same date for a1 insert into #test ('a2','2011-02-11 10:57:22.080''5433') -- older date for a2 insert into #test ('a2','2011-02-12 15:57:22.080','5678') -- newer date for a2 select * from #test t1 inner join #test t2 on t1.descr = t2.descr where ??
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.