?? SQL View on SQL Server Times out but in Access it works, what's up? (1 Viewer)

BEGIN TRANSACTION;
TRUNCATE TABLE aTable;
SELECT * FROM aTable;
COMMIT;

SELECT     PropertyFK, PeriodYear, PeriodQuarter, [1] AS [Cash], [2] AS [Accounts Receivable Tenants], [3] AS [Accounts Receivable Other], 
                      [4] AS [Prepaid Expenses], [5] AS [Tenant Security Deposits], [6] AS [Other Current Assets], [7] AS [Replacement Reserves], 
                      [8] AS [Tax and Escrow Insurance], [9] AS [Operating Reserve], [10] AS [Other Reserve], [11] AS [Land], [12] AS [Buildings], 
                      [13] AS [Equipment and Furniture], [14] AS [Accumulated Depreciation], [15] AS [AR Syndication Proceeds], [16] AS [Amortized Expenses], 
                      [17] AS [Other Assets], [18] AS [Accounts Payable], [19] AS [Accrued Expense], [20] AS [Accrued Interest], [21] AS [Accrued Property Tax], 
                      [22] AS [Tenant Security Deposit Liability], [23] AS [Current Notes Payable], [24] AS [Other Current Liabilities], [25] AS [Hard Long Term Debt], 
                      [26] AS [Deferred Soft Debt], [27] AS [Deferred Soft Interest], [28] AS [Debt Added], [29] AS [GP Loans], [30] AS [Development Fee Payable], 
                      [31] AS [Accrued LP Fees Payable], [32] AS [Accrued GP Fees Payable], [33] AS [Other Long Term Liabilities], [34] AS [Limited Partners Capital], 
                      [35] AS [General Partners Capital], [36] AS [Other Capital Account]
FROM         (SELECT     dbo.AccountBalance.PropertyFK, dbo.AccountBalance.PeriodYear, dbo.AccountBalance.PeriodQuarter, dbo.AccountBalance.AccountFK, 
                                              dbo.AccountBalance.Amount
                       FROM          dbo.AccountBalance INNER JOIN
                                              dbo.LUAccount ON dbo.AccountBalance.AccountFK = dbo.LUAccount.AccountID INNER JOIN
                                              dbo.LUAccountCategory ON dbo.LUAccount.AccountCategoryFK = dbo.LUAccountCategory.AccountCategoryID INNER JOIN
                                              dbo.LUAccountType ON dbo.LUAccountCategory.AccountTypeFK = dbo.LUAccountType.AccountTypeID
                       WHERE      (dbo.LUAccountType.StatementTypeFK = 1)) A PIVOT (SUM(Amount) FOR AccountFK IN ([1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12], [13], 
                      [14], [15], [16], [17], [18], [19], [20], [21], [22], [23], [24], [25], [26], [27], [28], [29], [30], [31], [32], [33], [34], [35], [36])) B