|
In response to
"are you getting duplicate records because of your links? nm -- nm"
by
groiny
|
I don't think so. It should "run" the View query on the SQL Server before returning the data, I would think...here's the sql:
Posted by
JaxSean (aka JaxSean)
Feb 17 '10, 14:15
|
SELECT dbo.v_Sean_FundedLoans_withRate.LenderRegistrationIdentifier AS Loan_Number, dbo.BORROWER._FirstName AS First,
dbo.BORROWER._LastName AS Last, dbo.Residence._StreetAddress AS Address, dbo.Residence._City AS City, dbo.Residence._State AS State,
dbo.Residence._PostalCode AS Zip, dbo.BORROWER._SSN AS SSN, dbo.BORROWER._BirthDate AS DOB,
dbo.v_Sean_FundedLoans_withRate._FundsOrderedDate AS Funded_Date
FROM dbo.loan_general LEFT OUTER JOIN
dbo.BORROWER ON dbo.loan_general.loanGeneral_Id = dbo.BORROWER.loanGeneral_Id LEFT OUTER JOIN
dbo.Residence ON dbo.BORROWER.loanGeneral_Id = dbo.Residence.loanGeneral_Id RIGHT OUTER JOIN
dbo.v_Sean_FundedLoans_withRate ON
dbo.loan_general.LenderRegistrationIdentifier = dbo.v_Sean_FundedLoans_withRate.LenderRegistrationIdentifier
WHERE (dbo.Residence.BorrowerResidencyType = 'Current') AND (dbo.BORROWER.BorrowerID = dbo.Residence.BorrowerID) AND
(dbo.v_Sean_FundedLoans_withRate._FundsOrderedDate > GETDATE() - 183)
|