| Author: Babu Akkandi 01 Jan 2009 | Member Level: Diamond | Rating:  Points: 2 |
Hi,
Use "Case When ..." Statement in your Query.
Hope it helps!
if you need some more help on this, please give your table structure, conditions to fetch the record, and output columns required?
Thanks and Regards,
Babu Akkandi
Microsoft Technology
|
| Author: Tejinder Singh Barnala 01 Jan 2009 | Member Level: Gold | Rating: Points: 3 |
muraleedharan , i have one dought
suppose your tale look like
name status1 status2 status3
test 1 0 0
test1 0 1 0
test2 0 0 1
test3 1 1 0
now you want result as
name status
test status1
test1 status2
test2 status3
test3 status1, status2
or
in any other way , please paste requested output for the table given by me, then only i will be able to provide you any solution.
name
Many Thanks
Tejinder Singh Barnala
/*I have the simplest tastes. I am always satisfied with the best*/
|