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
 SQL Server 2008 Forums
 Transact-SQL (2008)
 synatx error ! convert

Author  Topic 

usafelix
Posting Yak Master

165 Posts

Posted - 2015-01-27 : 21:34:55
case when trx_acc_amt<1000
then trx_acc_amt/nullif((Sum(
case when salesman_code is null or salesman_code=' ' then 0 else 1 end +
case when salesman_code2 is null or salesman_code2=' ' then 0 else 1 end +
case when salesman_code3 is null or salesman_code3=' ' then 0 else 1 end +
case when salesman_code4 is null or salesman_code4=' ' then 0 else 1 end +
case when salesman_code5 is null or salesman_code5=' ' then 0 else 1 end +
case when salesman_code6 is null or salesman_code6=' ' then 0 else 1 end)),0) else
trx_acc_amt / 2
end as bonus,
--------- error in this column
convert(varchar, convert(decimal(5,2), 100.0 * (trx_acc_amt)/(bonus)))+'%' as percentof

From test_table

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-01-27 : 21:41:51
it looks like you have posted the same question four or five times in this forum today. Please don't do that. it makes people less likely to help you.
Go to Top of Page
   

- Advertisement -