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 |
|
learntsql
524 Posts |
 Posted - 2010-01-06 : 02:01:36
|
| Hi...I have two columnsAccountNumber and Description .Account number may be duplicated for for different transactionsas sample data likeAccountNumber--Description--Date 100--Diposited 10K--Date1 100--Balance Check--Date1 101--Withdrawn 5K--Date1 100--Withdrawn 5K--Date2 100--Balance check--Date2 101--TPT 1K--Date2My Output should be as in two columnsAccountNumber -- TransactionDiscription100 -- Diposited 10K on Date1,Balance Check on Date1,Withdrawn 5K on Date2,Balance check on Date2101 -- Withdrawn 5K on Date1,TPT 1K on Date2in tow rows.i.e if many transaction done on same account on same or different dates i need to combine in single row as per date ASC/DESC order.Thanks in advance. |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2010-01-06 : 02:07:05
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254 |
 |
|
|
learntsql
524 Posts |
Posted - 2010-01-06 : 04:39:34
|
| Thank you bklr,that was great post. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-06 : 04:41:41
|
| also given herehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=137910 |
|
|
|
|
|
|
How to make duplicateRows in Single Row