Как переобразовать из SQL в X++?
Можно ли как-нибудь преобразовать следующие запросы из SQL в X++?
1) select SalesId from SalesLine where cast(ConfirmedDlv as int) - cast(createdDate as int) >= 1
2) select SalesId from SalesLine where convert(varchar(10),createdDate,103) = '25/07/2004'
3) select cast(count(RecId) as real)/7 as 'www' from SalesLine group by SalesId
4) select cast(ConfirmedDlv as int) - cast(createdDate as int) as 'www' from SalesLine
|