Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.
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.