把以下X++ sql代码转换成sqlserver 代码SELECT FIRSTFAST FORUPDATE FROM IdcfPurchLineBackOrderWorkspaceIdcfPurchLineBackOrderWorkspace ORDER BY IdcfPurchLineBackOrderWorkspaceExpectedDate ASC IdcfPurchLineBackOrd

以下是将X++代码转换成SQL Server代码的结果：

SELECT TOP (100) PERCENT * FROM IdcfPurchLineBackOrderWorkspace WITH (UPDLOCK) ORDER BY IdcfPurchLineBackOrderWorkspace.ExpectedDate ASC, IdcfPurchLineBackOrderWorkspace.ConfirmedDlv ASC WHERE (PurchStatus = 1) AND (NOT (PurchReceivedNow = 0)) JOIN InventDim WITH (UPDLOCK) ON IdcfPurchLineBackOrderWorkspace.InventDimId = InventDim.inventDimId LEFT OUTER JOIN EcoResCategory WITH (UPDLOCK) ON IdcfPurchLineBackOrderWorkspace.ProcurementCategory = EcoResCategory.RecId JOIN PurchTable WITH (UPDLOCK) ON IdcfPurchLineBackOrderWorkspace.PurchId = PurchTable.PurchId AND (IdcfProductReceiptId = N'hongmin.liang') AND (DocumentState = 30 OR DocumentState = 40