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 |
|
mohan.pati
Starting Member
7 Posts |
 Posted - 2009-02-17 : 03:45:12
|
| select * from asr_belgium_testin the table one column is there that column is asr _succ and the value is 0.47413249211356467we need to get the result if the ASR_succ value less than 51% |
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2009-02-17 : 03:48:39
|
| select * from asr_belgium_test where asr_succ < ( 51/100)*(0.47413249211356467) |
 |
|
|
sridhar.dbe
Starting Member
34 Posts |
Posted - 2009-02-17 : 03:54:11
|
| declare @t1 table(asr_succ decimal(10,7))insert into @t1select 0.47413249211356467 as 'asr _succ' union allselect 0.67413249211356467 as 'asr _succ' union allselect 0.57413249211356467 as 'asr _succ'---1----select * from @t1 where asr_succ < 0.51---2----select * from @t1 where (asr_succ*100) < 51---3----select * from @t1 where (asr_succ) <((1.0*51)/100) |
|
|
|
mohan.pati
Starting Member
7 Posts |
Posted - 2009-02-17 : 04:03:30
|
| i need to get the data if ASR_succ Percentage is Less than 51%.that valuse changing every day |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-02-17 : 05:58:34
|
| Did you try Sridhar's query ? Let us know if you see a problem. |
|
|
|
|
|
|
sal Statemrnt