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 |
|
usafelix
Posting Yak Master
165 Posts |
 Posted - 2015-02-11 : 21:40:10
|
| Anyone help ?I want to change the display message when else is 0 to show "non active member", how to edit this query for this result .---------------------------------------------------------------Current Query cast(sum(case when trx_date > dateadd(month, -3, getdate()) then 1 else 0 end) as varchar(10))+ ' Active Member := '+ user_member---------------------------------------------------------------I try this query but not work and prompt error.cast(sum(case when trx_date > dateadd(month, -3, getdate()) then 1 else "non active" end) as varchar(10))+ ' Active Member := '+ user_member----------------------------------------------------------------please help to edit my query . Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
show message ! help