I have a sql query specific to informix and syntactically not valid in MS SQL Server.
The sql query is,
select supplier,dated,item,type,reference,local_amount from payments p
where p.supplier=:supplier order by dated
I need you help to convert that sql query to MS SQL Server understandable query.
The syntax looks fine for MS SQL except for the :supplier part. I'm going to guess that your code is somehow substituting a valid value in place of the :supplier placeholder. Otherwise the query makes no sense at all even in INFORMIX. So assuming that p.supplier is an integer, then a valid syntax would be . . .
p.supplier = 2468