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 |
JanakiRam
Starting Member
22 Posts |
Posted - 2013-07-17 : 08:06:29
|
Hi.,I have a result set like below mentioned Customer_Ledger_ID Date Payment_Type Payment_Detail_Number Credit Debit 17 07/17/2013 Card XXXX XXXX XXXX 1111 130.00 0 18 07/17/2013 Card XXXX XXXX XXXX 1111 0 130.00 19 07/17/2013 Card XXXX XXXX XXXX 1111 63.17 0 20 07/17/2013 Card XXXX XXXX XXXX 1111 0 63.17but i need a result set Customer_Ledger_ID Date Payment_Type Payment_Detail_Number Credit Debit 18 07/17/2013 Card XXXX XXXX XXXX 1111 0 130.00 17 07/17/2013 Card XXXX XXXX XXXX 1111 130.00 0 20 07/17/2013 Card XXXX XXXX XXXX 1111 0 63.17 19 07/17/2013 Card XXXX XXXX XXXX 1111 63.17 0like thisJanakiRam |
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-17 : 08:12:16
|
quote: Originally posted by JanakiRam Hi.,I have a result set like below mentioned Customer_Ledger_ID Date Payment_Type Payment_Detail_Number Credit Debit 17 07/17/2013 Card XXXX XXXX XXXX 1111 130.00 0 18 07/17/2013 Card XXXX XXXX XXXX 1111 0 130.00 19 07/17/2013 Card XXXX XXXX XXXX 1111 63.17 0 20 07/17/2013 Card XXXX XXXX XXXX 1111 0 63.17but i need a result set Customer_Ledger_ID Date Payment_Type Payment_Detail_Number Credit Debit 18 07/17/2013 Card XXXX XXXX XXXX 1111 0 130.00 17 07/17/2013 Card XXXX XXXX XXXX 1111 130.00 0 20 07/17/2013 Card XXXX XXXX XXXX 1111 0 63.17 19 07/17/2013 Card XXXX XXXX XXXX 1111 63.17 0like thisJanakiRam
Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=186890 |
|
|
|
|
|