S
scottemick
Guest
SELECT * FROM (SELECT R.RegionID , R.Name Region , E.EntityID , E.Name Location , Netsales , Year(dt_StartBusDate) Period , DayOfWeek(dt_StartBusDate) DOW FROM PUB.Entity E INNER JOIN PUB.eDB_MajorGroupTotals T ON E.EntityID = T.EntityID INNER JOIN PUB.Region R ON E.RegionID = R.RegionID WHERE dt_StartBusDate BETWEEN '07-20-14' AND '07-26-14' ) T1 INNER JOIN T1.RegionId = T2.RegionId AND T1.EntityId = T2.EntityId AND T1.DOW=T2.DOW (SELECT R.RegionID , R.Name Region , E.EntityID , E.Name Location , Netsales , Year(dt_StartBusDate) Period , DayOfWeek(dt_StartBusDate) DOW FROM PUB.Entity E INNER JOIN PUB.eDB_MajorGroupTotals T ON E.EntityID = T.EntityID INNER JOIN PUB.Region R ON E.RegionID = R.RegionID WHERE dt_StartBusDate BETWEEN '07-19-13' AND '07-25-13' ) T2 WITH (NOLOCK) Each of the two selects runs quickly and returns in a few sconds. Each returns 1,000 rows. So what does progress just sit and spin forever when I try to join the two together?
Continue reading...
Continue reading...