Hi All,

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.

Thanks

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 . . .

select
supplier,
dated,
item,
[type],
reference,
local_amount
from
payments p
where
p.supplier = 2468
order by
dated