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 |
|
DENIZ3E
Yak Posting Veteran
56 Posts |
 Posted - 2005-11-23 : 19:25:41
|
| HI,ITEM-------ID AMOUNT---- ------10 10 SELECT AMOUNT FROM ITEM WHERE ID=1000RETURN------0 ROWSI WANT TO RETURN-------0.0 BUT I DONT USE (SELECT CASE WHEN COUNT(*)=0 THEN 0 ELSE MAX(AMOUNT) END FROM ITEM WHERE ID=1000 ) |
|
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
Posted - 2005-11-23 : 19:36:30
|
| i am not sure what u want to achieve.but here is it.if not exists(SELECT AMOUNT FROM AMOUNT WHERE resourceid=1000) begin select convert(varchar,0.0)endmk_garg |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-23 : 23:57:59
|
| Where do you want to show this?If you use Front End Application, then validate thereMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
ISEMPTY