Link to home
Start Free TrialLog in
Avatar of s_khan
s_khanFlag for United States of America

asked on

SQL "multi-part identifier cannot be bound" Error

I have to create a View that is extremely similar to another view expect for changes in Field Identifier values. I used the first as a template for the one I am trying to create. As per usual, I have looked at this thing a 1000 times and know there must be a disconnect or typo somewhere that I am not seeing.

I get the following two errors.

Msg 4104, Level 16, State 1, Procedure vPVTDetail, Line 2
The multi-part identifier "A379.EntityID" could not be bound.
Msg 4104, Level 16, State 1, Procedure vPVTDetail, Line 2
The multi-part identifier "A46.EntityID" could not be bound.

CREATE VIEW [dbo].[vPVTDetail] AS  
SELECT A1.EntityID,[PVT Loan Name],ParentEntityID,[Base],[Loan Date],[Finance Terms],[Principal],[DSRF Rate],[Amortization Term],[DSCR],[Year Sized],[Int. Only Period Info],[Int. Only Period - Yrs],[Benchmark Index (Period)],[Credit Spread],[Underlying Rate Per],[As of Date Per],[Index Information],[Benchmark Index],[Underlying Rate In],[As of Date Ind],[BPS Spread / Index],[Credit Spread - bps],[Lockbox/Servicing Fee],[Credit Enhancement/Insu],[Forward Premium - bps],[Other - bps],0 AS [Tot. Interest Rate],[Fees, Costs, Exp. & Res],[Underwriting Fee%],0 AS [Underwriting Fee Amt],[Debt. Serv. Reserve - mo],[Debt Serv. Reserve $],[Surety Policy Cost $],[Max Annual Debt Serv.],[Annual Reg. Costs],[Annual Trustee Fees],[Annual Surveillance Fees],[Legal Expenses $],[Rating Agency $],[Transfer Taxes $],[Title Insurance $],[Surveys $],[Bond Fee $],[Commitment Fee $],[Other Third Party $],[Environmental Fee $],[Appraisals $],[Other Expenses, Costs and Fees],0 AS [Total Exp. $],0 AS [Total Exp. % of Princ],0 AS [Principal Minus Expenses],[All-In Finance Percent],[Interest/Loan Life],[All-In Finance Cost],[Spec. Prov. (PEP 74,83)],[Min DCR(IDP)],[Min DCR(Post IDP)]
FROM ( SELECT EntityID,EntityName AS [PVT Loan Name] 
FROM dbo._EntityName WHERE EntityType = 105 AND IsDeleted = 0) A1 
LEFT JOIN ( SELECT EntityID,RowNumber,CAST(DetailValue AS int) AS ParentEntityID,EntityName AS [Base] 
FROM dbo._DetailsEntity WHERE FieldID = 9320) A2 ON A1.EntityID = A2.EntityID 
LEFT JOIN ( SELECT EntityID,RowNumber,CAST(DetailValue AS datetime) AS [Loan Date] 
FROM dbo._DetailsVarchar WHERE FieldID = 9438) A3 ON A1.EntityID = A3.EntityID 
LEFT JOIN ( SELECT EntityID,RowNumber,CAST(DetailValue AS money) AS [Finance Terms] 
FROM dbo._DetailsVarchar WHERE FieldID = 9336) A4 ON A1.EntityID = A4.EntityID 
LEFT JOIN ( SELECT EntityID,RowNumber,CAST(DetailValue AS decimal(19,4)) AS [Principal]

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of s_khan

ASKER

Thank you so much for your speedy reply. Although your suggestion to rewrite would probably be a fantastic idea, I was able to find the boo-boos that produced the errors. The error text did not reference where the typos were, making things difficult.

"A379.EntityID" turned out to be "A37.EntityID"
AND
I had two instances of "A46.EntityID"
Avatar of s_khan

ASKER

Thank you for your help. Your suggestion raised some good questions for me and will help in my learning.