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.
| Author |
Topic |
|
nalin_769
Starting Member
16 Posts |
 Posted - 2008-08-29 : 06:02:41
|
| When I run a sql query result will be display below formatLoan No Bank Name Loan Amount Reason Amount Taken 154 BANK-1 83450.0000 IF 3450.0154 BANK-1 83450.0000 PCL 30000.0154 BANK-1 83450.0000 WCL 50000.0155 BANK-1 271063.0000 IF 70000.0155 BANK-1 271063.0000 PCL 50000.0155 BANK-1 271063.0000 WCL 80000.0160 BANK-1 93186.0000 PCL 50000.0164 BANK-1 236639.0000 PCL 36000.0165 BANK-1 153771.0000 PCL 100000.0192 BANK-1 480941.0000 IF 80000.0But I need is Loan No Bank Name Loan Amount IF PCL WCL154 BANK-1 83450.0000 3450.0 30000.0 50000.0155 BANK-1 271063.0000 70000.0 50000.0 80000.0160 BANK-1 93186.0000 0 50000.0 0164 BANK-1 236639.0000 0 36000.0 0How do I create according to this format?My Sql query isSELECT LOAN.LoanNo, BANK.BankName, LOAN.LoanAmount, REASONS.Reasons, SUM(dbo.LOAN_REQUEST.ReuqestAmount) AS AmountTakenFROM LOAN INNER JOIN LOAN_REQUEST ON LOAN.LoanRefCode = LOAN_REQUEST.LoanRefCode INNER JOIN BANK ON LOAN.BankCode = BANK.BankCode INNER JOIN REASONS ON LOAN_REQUEST.RequestReason = REASONS.ReasonCodeGROUP BY LOAN.LoanNo, BANK.BankName, LOAN.LoanAmount, REASONS.ReasonsORDER BY LOAN.LoanNo |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-29 : 06:11:25
|
| [code]SELECT t.[Loan No],t.[Bank Name],t.[Loan Amount],MAX(CASE WHEN [Reason]='IF' THEN [Amount Taken]ELSE NULL END) AS IF,MAX(CASE WHEN [Reason]='PCL'THEN [Amount Taken]ELSE NULL END) AS PCL,MAX(CASE WHEN [Reason]='WCL' THEN [Amount Taken]ELSE NULL END) AS WCLFROM (Yourqueryhere) tGROUP BY t.[Loan No],t.[Bank Name],t.[Loan Amount][/code] |
 |
|
|
nalin_769
Starting Member
16 Posts |
Posted - 2008-08-29 : 06:47:31
|
| It's work thanks visakh |
|
|
|
|
|
|
|
|
Sql Query