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
 General SQL Server Forums
 New to SQL Server Programming
 Appear once in data

Author  Topic 

peace
Constraint Violating Yak Guru

420 Posts

Posted - 2012-05-23 : 04:32:19
BookingNo Journey PaymentMethod Total
123456 UK-US Visa $100
123456 US-UK Visa $100

How can i make the paymentmethod and total field to appear once?

BookingNo Journey PaymentMethod Total
123456 UK-US Visa $100
123456 US-UK

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2012-05-23 : 04:39:37
You should do that in your front end if possible.


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

peace
Constraint Violating Yak Guru

420 Posts

Posted - 2012-05-23 : 04:45:18
There is no way i can apply in my query?

It seems duplicate if appear twice.
Go to Top of Page
   

- Advertisement -