X++ SQL 代码转换为 SQL Server SQL 代码

以下是将给定的 X++ SQL 代码转换为 SQL Server 的 SQL 代码：\n\n\nDECLARE @taxTransCur8 TABLE (TaxValue INT)\nDECLARE @taxTransCur10 TABLE (TaxValue INT)\nDECLARE @custInvoiceJour_WCur TABLE (CustConsInvoice_JP INT)\nDECLARE @custInvoiceJourCur TABLE (RecId INT, SalesId INT, InvoiceId INT, InvoiceDate DATE, numberSequenceGroup INT)\nDECLARE @custInvoiceTransCur TABLE (SalesId INT, InvoiceId INT, InvoiceDate DATE, numberSequenceGroup INT, RecId INT, TableId INT)\nDECLARE @ledgerJournalTransCur TABLE (JournalNum INT, Invoice INT, TransDate DATE, Voucher INT, RecId INT, LedgerDimension INT)\nDECLARE @dimensionAttributeValueCombinationCur TABLE (RecId INT, DisplayValue VARCHAR(50))\n\n-- 获取税率为 10% 的 [転記消費税]\nINSERT INTO @custInvoiceJour_WCur\nSELECT CustConsInvoice_JP\nFROM custInvoiceJour_WCur\nWHERE CustConsInvoice_JP = custConsInvoice_JP.RecId\n\nINSERT INTO @custInvoiceJourCur\nSELECT RecId, SalesId, InvoiceId, InvoiceDate, numberSequenceGroup\nFROM custInvoiceJourCur\nWHERE RecId = custInvoiceJour_WCur.CustInvoiceJour\n\nINSERT INTO @custInvoiceTransCur\nSELECT SalesId, InvoiceId, InvoiceDate, numberSequenceGroup, RecId, TableId\nFROM custInvoiceTransCur\nWHERE SalesId = custInvoiceJourCur.SalesId\nAND InvoiceId = custInvoiceJourCur.InvoiceId\nAND InvoiceDate = custInvoiceJourCur.InvoiceDate\nAND numberSequenceGroup = custInvoiceJourCur.numberSequenceGroup\n\nINSERT INTO @ledgerJournalTransCur\nSELECT JournalNum, Invoice, TransDate, Voucher, RecId, LedgerDimension\nFROM ledgerJournalTransCur\nWHERE JournalNum = journalBatchNumber\nAND Invoice = custInvoiceJourCur.InvoiceId\nAND TransDate = custInvoiceJourCur.InvoiceDate\nAND Voucher = custInvoiceJourCur.LedgerVoucher\n\nINSERT INTO @dimensionAttributeValueCombinationCur\nSELECT RecId, DisplayValue\nFROM dimensionAttributeValueCombinationCur\nWHERE RecId = ledgerJournalTransCur.LedgerDimension\nAND DisplayValue = custInvoiceJourCur.InvoiceAccount\n\nSELECT SUM(SourceBaseAmountCur), SUM(SourceTaxAmountCur)\nFROM taxTransCur10\nWHERE TaxValue = 10\nAND (\n (SourceRecId = custInvoiceTransCur.RecId AND SourceTableId = custInvoiceTransCur.TableId)\n OR (SourceRecId = ledgerJournalTransCur.RecId AND SourceTableId = ledgerJournalTransCur.TableId)\n)\nGROUP BY taxTransCur10.TaxValue\n\n\n请注意，这只是将 X++ 代码转换为 SQL Server 的语法，可能需要根据实际情况进行调整和优化。