把以下X++ sql代码转换成sqlserver代码：SELECT FROM IdcfPurchApprovalInfoIdcfPurchApprovalInfo GROUP BY IdcfPurchApprovalInfoIdcfPurchOrderId WHERE IdcfPurchApprovalInfoIdcfDrafterDept != && IdcfCodeLine_1_1Id

以下是转换后的SQL Server代码：

SELECT * FROM IdcfPurchApprovalInfo INNER JOIN IdcfCodeLine AS IdcfCodeLine_1 ON IdcfPurchApprovalInfo.IdcfDrafterDept LIKE IdcfCodeLine_1.IdcfCodeFreeStrSpace2 + '%' LEFT JOIN IdcfCodeLine AS IdcfCodeLine_1_1 ON IdcfCodeLine_1.IdcfCodeFreeStrSpace = IdcfCodeLine_1_1.IdcfCodeFreeStrSpace WHERE IdcfPurchApprovalInfo.IdcfPurchOrderId IS NOT NULL AND (IdcfPurchApprovalInfo.IdcfDrafterDept != '' AND (IdcfCodeLine_1_1.IdcfCodeFreeStrSpace2 = '20' OR IdcfCodeLine_1_1.IdcfCodeFreeStrSpace2 = '20*' OR IdcfCodeLine_1_1.IdcfCodeFreeStrSpace2 = '') AND (IdcfPurchApprovalInfo.IdcfDrafterId = 'hongmin.liang' OR IdcfPurchApprovalInfo.IdcfApplicantId = 'hongmin.liang')) AND IdcfPurchApprovalInfo.IdcfDrafterDept IS NOT NULL AND IdcfCodeLine_1_1.IdcfCodeFreeStrSpace2 IS NOT NULL AND IdcfCodeLine_1.IdcfTypeCd = N'355' AND IdcfCodeLine_1_1.IdcfTypeCd = N'355'