I need help with this Query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

I need help with this Query

Author

Topic

skreczko
Starting Member

6 Posts

Posted - 2010-10-13 : 10:56:48

Hello Everyone,
Does anyone know how to fix this?
thanks

Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "mwlLoanApp.ID" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "mwlLoanApp.ID" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "mwlLoanApp.ID" could not be bound.

MY QuerySELECT
MIN(mwlApprovalStatus.StatusDateTime) AS DSREC,
MIN(mwlApprovalStatus.StatusMWCode) AS StatusMWCode,
MIN(mwlLoanApp.CurrentStatus) AS CurrentStatus,
mwlLoanApp.LoanNumber,
mwlLoanData.LoanProgramName,
MIN(mwlLoanData.NoteRate) AS NoteRate,
MIN(mwlLoanData.BaseNoteAmt) AS BaseNoteAmt,
MIN(mwlLoanApp.OriginatorName) AS OriginatorName,
MIN(mwlLoanData.AdjustedNoteAmt) AS Balance,
MIN(mwlLoanApp.DateOfDocuments) AS DateOfDocuments,
MIN(mwlLoanApp.LockExpirationDate) AS LockExpirationDate,
MIN(mwlLoanApp.LockStatus) AS LockStatus,
MIN(mwlLoanApp.RescissionDate) AS RescissionDate,
MIN(mwlLoanApp.EstCloseDate) AS EstCloseDate,
MIN(mwlLoanApp.LoanPurpose1003) AS LoanPurpose,
MIN(mwlLoanApp.CurrDecStatusDate) AS CurrDecStatusDate,
MIN(mwlLoanApp.LockDate) AS LockDate,
MIN(mwlLoanApp.ProcessorName) AS ProcessorName,
MIN(mwlBorrower.LastName) AS Lastname,
MIN(mwlBorrower.SequenceNum) AS SequenceNum,
Min(mwlHMDA.LoanSoldStatus) AS LoanSoldStatus
FROM mwlLoanApp AS mwlLoanApp INNER JOIN
mwlLoanData AS mwlLoanData INNER JOIN
mwlBorrower AS mwlBorrower INNER JOIN
mwlApprovalStatus AS mwlApprovalStatus INNER JOIN
mwlHMDA AS mwlHMDA
ON mwlHMDA.LoanApp_ID = mwlLoanApp.ID
ON mwlBorrower.LoanApp_ID = mwlLoanApp.ID
ON mwlApprovalStatus.LoanApp_ID = mwlLoanApp.ID
ON mwlLoanData.ObjOwner_ID = mwlLoanApp.ID
GROUP BY mwlLoanData.LoanProgramName, mwlLoanApp.LoanNumber
ORDER BY mwlLoanData.LoanProgramName, mwlLoanApp.LoanNumber

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-10-13 : 11:00:30

Have a look at your table "mwlLoanApp" - is there a column that is called ID?

No, you're never too old to Yak'n'Roll if you're too young to die.

Sachin.Nand

2937 Posts

Posted - 2010-10-13 : 13:34:57

Chnge your query to this


SELECT
MIN(mwlApprovalStatus.StatusDateTime) AS DSREC,
MIN(mwlApprovalStatus.StatusMWCode) AS StatusMWCode,
MIN(mwlLoanApp.CurrentStatus) AS CurrentStatus,
mwlLoanApp.LoanNumber,
mwlLoanData.LoanProgramName,
MIN(mwlLoanData.NoteRate) AS NoteRate,
MIN(mwlLoanData.BaseNoteAmt) AS BaseNoteAmt,
MIN(mwlLoanApp.OriginatorName) AS OriginatorName,
MIN(mwlLoanData.AdjustedNoteAmt) AS Balance,
MIN(mwlLoanApp.DateOfDocuments) AS DateOfDocuments,
MIN(mwlLoanApp.LockExpirationDate) AS LockExpirationDate,
MIN(mwlLoanApp.LockStatus) AS LockStatus,
MIN(mwlLoanApp.RescissionDate) AS RescissionDate,
MIN(mwlLoanApp.EstCloseDate) AS EstCloseDate,
MIN(mwlLoanApp.LoanPurpose1003) AS LoanPurpose,
MIN(mwlLoanApp.CurrDecStatusDate) AS CurrDecStatusDate,
MIN(mwlLoanApp.LockDate) AS LockDate,
MIN(mwlLoanApp.ProcessorName) AS ProcessorName,
MIN(mwlBorrower.LastName) AS Lastname,
MIN(mwlBorrower.SequenceNum) AS SequenceNum,
Min(mwlHMDA.LoanSoldStatus) AS LoanSoldStatus
FROM mwlLoanApp INNER JOIN mwlHMDA ON mwlHMDA.LoanApp_ID = mwlLoanApp.ID
INNER JOIN mwlBorrower  ON mwlBorrower.LoanApp_ID = mwlLoanApp.ID
INNER JOIN mwlApprovalStatus ON mwlApprovalStatus.LoanApp_ID = mwlLoanApp.ID
INNER JOIN mwlLoanData ON mwlLoanData.ObjOwner_ID = mwlLoanApp.ID
GROUP BY mwlLoanData.LoanProgramName, mwlLoanApp.LoanNumber
ORDER BY mwlLoanData.LoanProgramName, mwlLoanApp.LoanNumber

PBUH

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-10-13 : 13:47:58

quote:

Originally posted by Sachin.Nand

Chnge your query to this


SELECT
MIN(mwlApprovalStatus.StatusDateTime) AS DSREC,
MIN(mwlApprovalStatus.StatusMWCode) AS StatusMWCode,
MIN(mwlLoanApp.CurrentStatus) AS CurrentStatus,
mwlLoanApp.LoanNumber,
mwlLoanData.LoanProgramName,
MIN(mwlLoanData.NoteRate) AS NoteRate,
MIN(mwlLoanData.BaseNoteAmt) AS BaseNoteAmt,
MIN(mwlLoanApp.OriginatorName) AS OriginatorName,
MIN(mwlLoanData.AdjustedNoteAmt) AS Balance,
MIN(mwlLoanApp.DateOfDocuments) AS DateOfDocuments,
MIN(mwlLoanApp.LockExpirationDate) AS LockExpirationDate,
MIN(mwlLoanApp.LockStatus) AS LockStatus,
MIN(mwlLoanApp.RescissionDate) AS RescissionDate,
MIN(mwlLoanApp.EstCloseDate) AS EstCloseDate,
MIN(mwlLoanApp.LoanPurpose1003) AS LoanPurpose,
MIN(mwlLoanApp.CurrDecStatusDate) AS CurrDecStatusDate,
MIN(mwlLoanApp.LockDate) AS LockDate,
MIN(mwlLoanApp.ProcessorName) AS ProcessorName,
MIN(mwlBorrower.LastName) AS Lastname,
MIN(mwlBorrower.SequenceNum) AS SequenceNum,
Min(mwlHMDA.LoanSoldStatus) AS LoanSoldStatus
FROM mwlLoanApp INNER JOIN mwlHMDA ON mwlHMDA.LoanApp_ID = mwlLoanApp.ID
INNER JOIN mwlBorrower  ON mwlBorrower.LoanApp_ID = mwlLoanApp.ID
INNER JOIN mwlApprovalStatus ON mwlApprovalStatus.LoanApp_ID = mwlLoanApp.ID
INNER JOIN mwlLoanData ON mwlLoanData.ObjOwner_ID = mwlLoanApp.ID
GROUP BY mwlLoanData.LoanProgramName, mwlLoanApp.LoanNumber
ORDER BY mwlLoanData.LoanProgramName, mwlLoanApp.LoanNumber

PBUH

Could you please hihglight your changes?
I can see no difference so far...

No, you're never too old to Yak'n'Roll if you're too young to die.

Sachin.Nand

2937 Posts

Posted - 2010-10-13 : 13:57:45

Original query

SELECT
MIN(mwlApprovalStatus.StatusDateTime) AS DSREC,
MIN(mwlApprovalStatus.StatusMWCode) AS StatusMWCode,
MIN(mwlLoanApp.CurrentStatus) AS CurrentStatus,
mwlLoanApp.LoanNumber,
mwlLoanData.LoanProgramName,
MIN(mwlLoanData.NoteRate) AS NoteRate,
MIN(mwlLoanData.BaseNoteAmt) AS BaseNoteAmt,
MIN(mwlLoanApp.OriginatorName) AS OriginatorName,
MIN(mwlLoanData.AdjustedNoteAmt) AS Balance,
MIN(mwlLoanApp.DateOfDocuments) AS DateOfDocuments,
MIN(mwlLoanApp.LockExpirationDate) AS LockExpirationDate,
MIN(mwlLoanApp.LockStatus) AS LockStatus,
MIN(mwlLoanApp.RescissionDate) AS RescissionDate,
MIN(mwlLoanApp.EstCloseDate) AS EstCloseDate,
MIN(mwlLoanApp.LoanPurpose1003) AS LoanPurpose,
MIN(mwlLoanApp.CurrDecStatusDate) AS CurrDecStatusDate,
MIN(mwlLoanApp.LockDate) AS LockDate,
MIN(mwlLoanApp.ProcessorName) AS ProcessorName,
MIN(mwlBorrower.LastName) AS Lastname,
MIN(mwlBorrower.SequenceNum) AS SequenceNum,
Min(mwlHMDA.LoanSoldStatus) AS LoanSoldStatus

FROM mwlLoanApp AS mwlLoanApp INNER JOIN
mwlLoanData AS mwlLoanData INNER JOIN
mwlBorrower AS mwlBorrower INNER JOIN
mwlApprovalStatus AS mwlApprovalStatus INNER JOIN
mwlHMDA AS mwlHMDA
ON mwlHMDA.LoanApp_ID = mwlLoanApp.ID
ON mwlBorrower.LoanApp_ID = mwlLoanApp.ID
ON mwlApprovalStatus.LoanApp_ID = mwlLoanApp.ID
ON mwlLoanData.ObjOwner_ID = mwlLoanApp.ID

GROUP BY mwlLoanData.LoanProgramName, mwlLoanApp.LoanNumber
ORDER BY mwlLoanData.LoanProgramName, mwlLoanApp.LoanNumber

My query


SELECT
MIN(mwlApprovalStatus.StatusDateTime) AS DSREC,
MIN(mwlApprovalStatus.StatusMWCode) AS StatusMWCode,
MIN(mwlLoanApp.CurrentStatus) AS CurrentStatus,
mwlLoanApp.LoanNumber,
mwlLoanData.LoanProgramName,
MIN(mwlLoanData.NoteRate) AS NoteRate,
MIN(mwlLoanData.BaseNoteAmt) AS BaseNoteAmt,
MIN(mwlLoanApp.OriginatorName) AS OriginatorName,
MIN(mwlLoanData.AdjustedNoteAmt) AS Balance,
MIN(mwlLoanApp.DateOfDocuments) AS DateOfDocuments,
MIN(mwlLoanApp.LockExpirationDate) AS LockExpirationDate,
MIN(mwlLoanApp.LockStatus) AS LockStatus,
MIN(mwlLoanApp.RescissionDate) AS RescissionDate,
MIN(mwlLoanApp.EstCloseDate) AS EstCloseDate,
MIN(mwlLoanApp.LoanPurpose1003) AS LoanPurpose,
MIN(mwlLoanApp.CurrDecStatusDate) AS CurrDecStatusDate,
MIN(mwlLoanApp.LockDate) AS LockDate,
MIN(mwlLoanApp.ProcessorName) AS ProcessorName,
MIN(mwlBorrower.LastName) AS Lastname,
MIN(mwlBorrower.SequenceNum) AS SequenceNum,
Min(mwlHMDA.LoanSoldStatus) AS LoanSoldStatus

FROM mwlLoanApp INNER JOIN mwlHMDA ON mwlHMDA.LoanApp_ID = mwlLoanApp.ID
INNER JOIN mwlBorrower  ON mwlBorrower.LoanApp_ID = mwlLoanApp.ID
INNER JOIN mwlApprovalStatus ON mwlApprovalStatus.LoanApp_ID = mwlLoanApp.ID
INNER JOIN mwlLoanData ON mwlLoanData.ObjOwner_ID = mwlLoanApp.ID

GROUP BY mwlLoanData.LoanProgramName, mwlLoanApp.LoanNumber
ORDER BY mwlLoanData.LoanProgramName, mwlLoanApp.LoanNumber

Check the red part....

PBUH

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-10-13 : 14:00:49

Thank you!
Oh boy - I was so blind...

No, you're never too old to Yak'n'Roll if you're too young to die.

Sachin.Nand

2937 Posts

Posted - 2010-10-13 : 14:13:54

quote:
Originally posted by webfred

Thank you!
Oh boy - I was so blind...

No, you're never too old to Yak'n'Roll if you're too young to die.

PBUH

skreczko
Starting Member

6 Posts

Posted - 2010-10-14 : 13:11:10

Thanks For the help that worked. I have to add MIN(mwlLoanData.FirstTimeBuyer) AS FirstT to the query. and I get this message:
Msg 8117, Level 16, State 1, Line 1
Operand data type bit is invalid for min operator.

My Query
SELECT
MIN(mwlApprovalStatus.StatusDateTime) AS DSREC,
MIN(mwlApprovalStatus.StatusMWCode) AS StatusMWCode,
MIN(mwlLoanApp.CurrentStatus) AS CurrentStatus,
mwlLoanApp.LoanNumber,
mwlLoanData.LoanProgramName,
MIN(mwlLoanData.NoteRate) AS NoteRate,
MIN(mwlLoanApp.OriginatorName) AS OriginatorName,
MIN(mwlLoanData.AdjustedNoteAmt) AS Balance,
MIN(mwlLoanApp.DateOfDocuments) AS DateOfDocuments,
MIN(mwlLoanApp.LockExpirationDate) AS LockExpirationDate,
MIN(mwlLoanApp.LockStatus) AS LockStatus,
MIN(mwlLoanApp.RescissionDate) AS RescissionDate,
MIN(mwlLoanApp.EstCloseDate) AS EstCloseDate,
MIN(mwlLoanApp.LoanPurpose1003) AS LoanPurpose,
MIN(mwlLoanApp.CurrDecStatusDate) AS CurrDecStatusDate,
MIN(mwlLoanApp.LockDate) AS LockDate,
MIN(mwlLoanApp.ProcessorName) AS ProcessorName,
MIN(mwlBorrower.LastName) AS Lastname,
MIN(mwlBorrower.SequenceNum) AS SequenceNum,
MIN(mwlLoanApp.DecisionStatus) AS DecisionStatus,
Min(mwlHMDA.LoanSoldStatus) AS LoanSoldStatus

FROM mwlLoanApp INNER JOIN mwlHMDA ON mwlHMDA.LoanApp_ID = mwlLoanApp.ID
INNER JOIN mwlBorrower ON mwlBorrower.LoanApp_ID = mwlLoanApp.ID
INNER JOIN mwlApprovalStatus ON mwlApprovalStatus.LoanApp_ID = mwlLoanApp.ID
INNER JOIN mwlLoanData ON mwlLoanData.ObjOwner_ID = mwlLoanApp.ID

GROUP BY mwlLoanData.LoanProgramName, mwlLoanApp.LoanNumber
ORDER BY mwlLoanData.LoanProgramName, mwlLoanApp.LoanNumber

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-10-14 : 13:17:41

Here you can see the possibilities on getting min(bitfield):
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=114671

No, you're never too old to Yak'n'Roll if you're too young to die.

skreczko
Starting Member

6 Posts

Posted - 2010-10-14 : 15:49:55

Thanks again.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-10-14 : 17:00:07