There's just not enough information to even begin to make a suggestion here. For example, we don't know what D_CalendarSKey is nor why there'd be a stock related subkey in a calendar table to begin with. The join in the "view" looks like it spawns a massive many-to-many join.
--Jeff Moden
Change is inevitable... Change for the better is not.