CREATE VIEW [dbo].[VW_DIM_Current_OrgStructure]

AS

SELECT CurrentVersion, OrgUnitID, OrgUnitName, OrgUnitManager, CompanyFlag, BR1, BRCode, SegmentFlag, PCFlag, CCFlag, RLFlag, SalesOrgFlag, LevelsDeep, ParentID,

...

I have a similar view which is linked to a store procedure to bring data in a table. It runs and eats al the memory eventually getting terminated by the...