If the option is selected, (which is always recommended if the collations are the same on both servers), then the WHERE clause is applied on the remote server. This, of...

SMV,

the syntax should be correct - try it that way:

select * from openquery(cvsc, 'select cast(sum(price * qty-ordered) as integer) as aliasname from ...')

the alias should be working - i had...

Well, I forgot to mention that I am not using openquery because the statement is generated by the erp system in my case and that's why I am using the...

Thank you very much for your fast replies.

I tried casting the sum as you suggested and it worked - the error is gone.

But now the statement takes even more time!...

I'm having this problem as well. Have you found a solution to this?

Thanks in advance,

mel