主頁 > 作業系統 > 上個月的AzureSQL試算表

上個月的AzureSQL試算表

2022-01-10 04:01:02 作業系統

我有一張資料表。每年的期初余額都是預先計算的，一月份總是有一個數字。我希望每個月的期初余額結轉，包括任何凈變動金額。因此，期初余額欄位（會計/交易）將被定義為AccountingOpeningBalance從年初到上個月月底的累積 AccountingNetChangeAmount)。我還將發布我正在嘗試做的截圖。在 SQL 中執行此操作的最佳方法是什么？這是另一個系統的所有資料的完整加載，因此不會輸入開始/結束日期。

*** 暫停進行進一步調查 ***

上個月的 Azure SQL 試算表

/****** Object:  Table [dbo].[RetrieveTrialBalanceTEST]    Script Date: 29/12/2021 17:04:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RetrieveTrialBalanceTEST](
    [Company] [int] NOT NULL,
    [MainAccount] [int] NOT NULL,
    [PortFolioProject] [int] NULL,
    [TransactionCurrency] [nvarchar](3) NOT NULL,
    [AccountingOpeningBalance] [numeric](38, 6) NULL,
    [AccountingNetChangeAmount] [numeric](38, 6) NULL,
    [TransactionOpeningBalance] [numeric](38, 6) NULL,
    [TransactionNetChangeAmount] [numeric](38, 6) NULL,
    [Month] [int] NULL,
    [Period] [nvarchar](4000) NULL,
    [Year] [int] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'AUD', CAST(-141194.000000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-205000.000000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), 1, N'JAN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'BMD', CAST(-27255.140000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-27255.140000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), 1, N'JAN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'CAD', CAST(-2428.080000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-3220.000000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), 1, N'JAN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'CHF', CAST(-220514.900000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-210500.000000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), 1, N'JAN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'EUR', CAST(-1213310.030000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-1084078.320000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), 1, N'JAN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'GBP', CAST(-2449684.590000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-1895760.520000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), 1, N'JAN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'USD', CAST(8235414.760000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(8235414.760000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), 1, N'JAN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 20698, N'USD', CAST(-3162799.570000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-3162799.570000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), 1, N'JAN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 20701, N'USD', CAST(-8538.750000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-8538.750000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), 1, N'JAN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 20706, N'CAD', CAST(-9189.700000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-12000.000000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), 1, N'JAN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'AUD', CAST(0.000000 AS Numeric(38, 6)), CAST(-17038.670000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-22378.080000 AS Numeric(38, 6)), 4, N'APR', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'AUD', CAST(0.000000 AS Numeric(38, 6)), CAST(-115.330000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-148.800000 AS Numeric(38, 6)), 5, N'MAY', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'AUD', CAST(0.000000 AS Numeric(38, 6)), CAST(-16453.140000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-21946.300000 AS Numeric(38, 6)), 7, N'JUL', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'AUD', CAST(0.000000 AS Numeric(38, 6)), CAST(-72603.980000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-100100.880000 AS Numeric(38, 6)), 8, N'AUG', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'BMD', CAST(0.000000 AS Numeric(38, 6)), CAST(-39.500000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-39.500000 AS Numeric(38, 6)), 5, N'MAY', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'CAD', CAST(0.000000 AS Numeric(38, 6)), CAST(-16671.250000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-20634.560000 AS Numeric(38, 6)), 4, N'APR', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'CAD', CAST(0.000000 AS Numeric(38, 6)), CAST(-27757.730000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-33660.000000 AS Numeric(38, 6)), 6, N'JUN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'CAD', CAST(0.000000 AS Numeric(38, 6)), CAST(-13185.850000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-16632.000000 AS Numeric(38, 6)), 7, N'JUL', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'CHF', CAST(0.000000 AS Numeric(38, 6)), CAST(-13370.400000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-12000.000000 AS Numeric(38, 6)), 2, N'FEB', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'CHF', CAST(0.000000 AS Numeric(38, 6)), CAST(-5417.500000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-5000.000000 AS Numeric(38, 6)), 4, N'APR', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'CHF', CAST(0.000000 AS Numeric(38, 6)), CAST(-84489.200000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-76000.000000 AS Numeric(38, 6)), 6, N'JUN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'CHF', CAST(0.000000 AS Numeric(38, 6)), CAST(-10898.000000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-10000.000000 AS Numeric(38, 6)), 7, N'JUL', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'CHF', CAST(0.000000 AS Numeric(38, 6)), CAST(-34316.100000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-31500.000000 AS Numeric(38, 6)), 8, N'AUG', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'EUR', CAST(0.000000 AS Numeric(38, 6)), CAST(-60065.090000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-49407.820000 AS Numeric(38, 6)), 1, N'JAN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'EUR', CAST(0.000000 AS Numeric(38, 6)), CAST(-60479.040000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-49863.170000 AS Numeric(38, 6)), 2, N'FEB', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'EUR', CAST(0.000000 AS Numeric(38, 6)), CAST(-12680.530000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-10630.000000 AS Numeric(38, 6)), 3, N'MAR', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'EUR', CAST(0.000000 AS Numeric(38, 6)), CAST(-147617.210000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-124488.790000 AS Numeric(38, 6)), 4, N'APR', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'EUR', CAST(0.000000 AS Numeric(38, 6)), CAST(-60692.420000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-49850.040000 AS Numeric(38, 6)), 5, N'MAY', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'EUR', CAST(0.000000 AS Numeric(38, 6)), CAST(-72969.800000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-59846.750000 AS Numeric(38, 6)), 6, N'JUN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'EUR', CAST(0.000000 AS Numeric(38, 6)), CAST(-67855.430000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-57475.380000 AS Numeric(38, 6)), 7, N'JUL', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'EUR', CAST(0.000000 AS Numeric(38, 6)), CAST(-89161.800000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-75624.430000 AS Numeric(38, 6)), 8, N'AUG', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'GBP', CAST(0.000000 AS Numeric(38, 6)), CAST(-358602.930000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-263658.790000 AS Numeric(38, 6)), 1, N'JAN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'GBP', CAST(0.000000 AS Numeric(38, 6)), CAST(-342658.990000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-246690.900000 AS Numeric(38, 6)), 2, N'FEB', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'GBP', CAST(0.000000 AS Numeric(38, 6)), CAST(-24548.700000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-17629.940000 AS Numeric(38, 6)), 3, N'MAR', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'GBP', CAST(0.000000 AS Numeric(38, 6)), CAST(-22602.180000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-16337.060000 AS Numeric(38, 6)), 4, N'APR', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'GBP', CAST(0.000000 AS Numeric(38, 6)), CAST(-408572.870000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-289051.220000 AS Numeric(38, 6)), 5, N'MAY', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'GBP', CAST(0.000000 AS Numeric(38, 6)), CAST(-81834.950000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-58166.600000 AS Numeric(38, 6)), 6, N'JUN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'GBP', CAST(0.000000 AS Numeric(38, 6)), CAST(-656762.450000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-476738.700000 AS Numeric(38, 6)), 7, N'JUL', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'GBP', CAST(0.000000 AS Numeric(38, 6)), CAST(-184405.370000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-134115.420000 AS Numeric(38, 6)), 8, N'AUG', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'USD', CAST(0.000000 AS Numeric(38, 6)), CAST(426074.270000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(426074.270000 AS Numeric(38, 6)), 1, N'JAN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'USD', CAST(0.000000 AS Numeric(38, 6)), CAST(466995.850000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(466995.850000 AS Numeric(38, 6)), 2, N'FEB', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'USD', CAST(0.000000 AS Numeric(38, 6)), CAST(42436.370000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(42436.370000 AS Numeric(38, 6)), 3, N'MAR', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'USD', CAST(0.000000 AS Numeric(38, 6)), CAST(211274.660000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(211274.660000 AS Numeric(38, 6)), 4, N'APR', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'USD', CAST(0.000000 AS Numeric(38, 6)), CAST(467332.520000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(467332.520000 AS Numeric(38, 6)), 5, N'MAY', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'USD', CAST(0.000000 AS Numeric(38, 6)), CAST(324603.360000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(324603.360000 AS Numeric(38, 6)), 6, N'JUN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'USD', CAST(0.000000 AS Numeric(38, 6)), CAST(908661.630000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(908661.630000 AS Numeric(38, 6)), 7, N'JUL', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 696, N'USD', CAST(0.000000 AS Numeric(38, 6)), CAST(523337.300000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(523337.300000 AS Numeric(38, 6)), 8, N'AUG', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 20698, N'USD', CAST(0.000000 AS Numeric(38, 6)), CAST(-7406.250000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-7406.250000 AS Numeric(38, 6)), 1, N'JAN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 20698, N'USD', CAST(0.000000 AS Numeric(38, 6)), CAST(-50487.420000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-50487.420000 AS Numeric(38, 6)), 2, N'FEB', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 20698, N'USD', CAST(0.000000 AS Numeric(38, 6)), CAST(-4525.400000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-4525.400000 AS Numeric(38, 6)), 3, N'MAR', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 20698, N'USD', CAST(0.000000 AS Numeric(38, 6)), CAST(-1927.850000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-1927.850000 AS Numeric(38, 6)), 4, N'APR', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 20698, N'USD', CAST(0.000000 AS Numeric(38, 6)), CAST(-55464.080000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-55464.080000 AS Numeric(38, 6)), 6, N'JUN', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 20698, N'USD', CAST(0.000000 AS Numeric(38, 6)), CAST(-143506.760000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-143506.760000 AS Numeric(38, 6)), 7, N'JUL', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 20698, N'USD', CAST(0.000000 AS Numeric(38, 6)), CAST(-142850.050000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-142850.050000 AS Numeric(38, 6)), 8, N'AUG', 2021)
GO
INSERT [dbo].[RetrieveTrialBalanceTEST] ([Company], [MainAccount], [PortFolioProject], [TransactionCurrency], [AccountingOpeningBalance], [AccountingNetChangeAmount], [TransactionOpeningBalance], [TransactionNetChangeAmount], [Month], [Period], [Year]) VALUES (1234, 123456, 20701, N'USD', CAST(0.000000 AS Numeric(38, 6)), CAST(-681.740000 AS Numeric(38, 6)), CAST(0.000000 AS Numeric(38, 6)), CAST(-681.740000 AS Numeric(38, 6)), 3, N'MAR', 2021)
GO

SELECT * FROM dbo.RetrieveTrialBalanceTEST ORDER BY Month

uj5u.com熱心網友回復：

我希望我正確地理解了你。如果是這樣，這是我的嘗試...

SELECT *, 
    [AccountingCumulativeOpeningBalance]  = (
        CASE [Month]
            WHEN 1 THEN 0
            ELSE 
            ( 
                ( SELECT SUM(AccountingNetChangeAmount)
                    FROM dbo.RetrieveTrialBalanceTEST AS I
                    WHERE I.Company = O.Company
                        AND I.MainAccount = O.MainAccount
                        AND I.PortFolioProject = O.PortFolioProject
                        AND I.TransactionCurrency = O.TransactionCurrency
                        AND I.Year = O.Year
                        AND I.Month < O.Month )   
                ( SELECT SUM(AccountingOpeningBalance)
                    FROM dbo.RetrieveTrialBalanceTEST AS I
                    WHERE I.Company = O.Company
                        AND I.MainAccount = O.MainAccount
                        AND I.PortFolioProject = O.PortFolioProject
                        AND I.TransactionCurrency = O.TransactionCurrency
                        AND I.Year = O.Year
                        AND I.Month = 1 )
                )
        END ),
    [TransactionCumulativeOpeningBalance]  = (
        CASE [Month]
            WHEN 1 THEN 0
            ELSE 
            ( 
                ( SELECT SUM(TransactionNetChangeAmount)
                    FROM dbo.RetrieveTrialBalanceTEST AS I
                    WHERE I.Company = O.Company
                        AND I.MainAccount = O.MainAccount
                        AND I.PortFolioProject = O.PortFolioProject
                        AND I.TransactionCurrency = O.TransactionCurrency
                        AND I.Year = O.Year
                        AND I.Month < O.Month )   
                ( SELECT SUM(TransactionOpeningBalance)
                    FROM dbo.RetrieveTrialBalanceTEST AS I
                    WHERE I.Company = O.Company
                        AND I.MainAccount = O.MainAccount
                        AND I.PortFolioProject = O.PortFolioProject
                        AND I.TransactionCurrency = O.TransactionCurrency
                        AND I.Year = O.Year
                        AND I.Month = 1 )
                )
        END )
FROM dbo.RetrieveTrialBalanceTEST AS O
ORDER BY Company, MainAccount, PortFolioProject, TransactionCurrency, Month

是不是很啰嗦？ 是的！能不能做得更好？ 大概吧！

我已經對輸出進行了核對，它通過每個屬性分組正確地將余額逐月向前流動。我認為聚合貨幣沒有意義，聚合每個屬性是有意義的。

另外，就個人而言，我會將這些資料存盤在另一個欄位中。對我來說，將資料添加回原始欄位不是必需的，并且會混淆源頭和計算的內容。

你可以在你的桌子上建立一個視圖，這基本上就是我的回答。

我希望這就是你所追求的。

uj5u.com熱心網友回復：

試試這樣的方法，我們允許在同一個月內同時出現期初余額和凈變化（通常發生在 1 月份）。

注意：我已將 AccountOpen 和 Account Net Change 包含在當月的 AccountBalance (ABal) 中，并在每年的每個后續月份累積，從下一年開始。

這同樣適用于 TransactionOpen 和 Transaction Net Change 等。

但是，讓我們調整邏輯以在每年開始的任何期初余額行之后應用凈變化行。

稍后，我們可以（如果需要）根據需要用今年最后一個可用月份的計算來填寫任何缺失的月度資料。

SELECT Year, Month AS Mon, Period, MainAccount AS Acct, PortFolioProject AS Folio, Company AS Comp, TransactionCurrency AS TCur
     , AccountingOpeningBalance   AS AOpen
     , AccountingNetChangeAmount  AS ANet
     , SUM(AccountingOpeningBalance    AccountingNetChangeAmount)  OVER (PARTITION BY Year, MainAccount, PortFolioProject, Company, TransactionCurrency ORDER BY Month, AccountingNetChangeAmount DESC) AS ABal
     , TransactionOpeningBalance  AS TOpen
     , TransactionNetChangeAmount AS TNet
     , SUM(TransactionOpeningBalance   TransactionNetChangeAmount) OVER (PARTITION BY Year, MainAccount, PortFolioProject, Company, TransactionCurrency ORDER BY Month, TransactionNetChangeAmount DESC) AS TBal
  FROM RetrieveTrialBalanceTEST
 WHERE TransactionCurrency = 'EUR'
 ORDER BY Company, MainAccount, PortFolioProject, TransactionCurrency, Year, Month, AccountingOpeningBalance
;

以下結果基于問題中的給定資料，加上一些復制的帶有 2022 年日期的重復行，以顯示每年如何重新開始計算。

此外，結果基于將以下過濾器添加到查詢中，僅顯示“EUR”相關結果，以簡化審查。

WHERE TransactionCurrency = 'EUR'

另請注意，我沒有對同一個月內的常見（開放/凈變化）行進行分組，但這很容易完成。我只是將它們與視窗函式相加。這僅在 1 月份可見，在當前資料中，開放和凈變化均非 0。

 ------ ------ -------- -------- ------- ------ ------ -------------- ------------- -------------- -------------- ------------- -------------- 
| Year | Mon  | Period | Acct   | Folio | Comp | TCur | AOpen        | ANet        | ABal         | TOpen        | TNet        | TBal         |
 ------ ------ -------- -------- ------- ------ ------ -------------- ------------- -------------- -------------- ------------- -------------- 
| 2021 |    1 | JAN    | 123456 |   696 | 1234 | EUR  | -1213310.030 |       0.000 | -1213310.030 | -1084078.320 |       0.000 | -1084078.320 |
| 2021 |    1 | JAN    | 123456 |   696 | 1234 | EUR  |        0.000 |  -60065.090 | -1273375.120 |        0.000 |  -49407.820 | -1133486.140 |
| 2021 |    2 | FEB    | 123456 |   696 | 1234 | EUR  |        0.000 |  -60479.040 | -1333854.160 |        0.000 |  -49863.170 | -1183349.310 |
| 2021 |    3 | MAR    | 123456 |   696 | 1234 | EUR  |        0.000 |  -12680.530 | -1346534.690 |        0.000 |  -10630.000 | -1193979.310 |
| 2021 |    4 | APR    | 123456 |   696 | 1234 | EUR  |        0.000 | -147617.210 | -1494151.900 |        0.000 | -124488.790 | -1318468.100 |
| 2021 |    5 | MAY    | 123456 |   696 | 1234 | EUR  |        0.000 |  -60692.420 | -1554844.320 |        0.000 |  -49850.040 | -1368318.140 |
| 2021 |    6 | JUN    | 123456 |   696 | 1234 | EUR  |        0.000 |  -72969.800 | -1627814.120 |        0.000 |  -59846.750 | -1428164.890 |
| 2021 |    7 | JUL    | 123456 |   696 | 1234 | EUR  |        0.000 |  -67855.430 | -1695669.550 |        0.000 |  -57475.380 | -1485640.270 |
| 2021 |    8 | AUG    | 123456 |   696 | 1234 | EUR  |        0.000 |  -89161.800 | -1784831.350 |        0.000 |  -75624.430 | -1561264.700 |
| 2022 |    1 | JAN    | 123456 |   696 | 1234 | EUR  | -1213310.030 |       0.000 | -1213310.030 | -1084078.320 |       0.000 | -1084078.320 |
 ------ ------ -------- -------- ------- ------ ------ -------------- ------------- -------------- -------------- ------------- --------------

完整的結果如下所示：

 ------ ------ -------- -------- ------- ------ ------ -------------- ------------- -------------- -------------- ------------- -------------- 
| Year | Mon  | Period | Acct   | Folio | Comp | TCur | AOpen        | ANet        | ABal         | TOpen        | TNet        | TBal         |
 ------ ------ -------- -------- ------- ------ ------ -------------- ------------- -------------- -------------- ------------- -------------- 
| 2021 |    1 | JAN    | 123456 |   696 | 1234 | AUD  |  -141194.000 |       0.000 |  -141194.000 |  -205000.000 |       0.000 |  -205000.000 |
| 2021 |    4 | APR    | 123456 |   696 | 1234 | AUD  |        0.000 |  -17038.670 |  -158232.670 |        0.000 |  -22378.080 |  -227378.080 |
| 2021 |    5 | MAY    | 123456 |   696 | 1234 | AUD  |        0.000 |    -115.330 |  -158348.000 |        0.000 |    -148.800 |  -227526.880 |
| 2021 |    7 | JUL    | 123456 |   696 | 1234 | AUD  |        0.000 |  -16453.140 |  -174801.140 |        0.000 |  -21946.300 |  -249473.180 |
| 2021 |    8 | AUG    | 123456 |   696 | 1234 | AUD  |        0.000 |  -72603.980 |  -247405.120 |        0.000 | -100100.880 |  -349574.060 |
| 2022 |    1 | JAN    | 123456 |   696 | 1234 | AUD  |  -141194.000 |       0.000 |  -141194.000 |  -205000.000 |       0.000 |  -205000.000 |
| 2022 |    4 | APR    | 123456 |   696 | 1234 | AUD  |        0.000 |  -17038.670 |  -158232.670 |        0.000 |  -22378.080 |  -227378.080 |
| 2022 |    5 | MAY    | 123456 |   696 | 1234 | AUD  |        0.000 |    -115.330 |  -158348.000 |        0.000 |    -148.800 |  -227526.880 |
| 2022 |    7 | JUL    | 123456 |   696 | 1234 | AUD  |        0.000 |  -16453.140 |  -174801.140 |        0.000 |  -21946.300 |  -249473.180 |
| 2021 |    1 | JAN    | 123456 |   696 | 1234 | BMD  |   -27255.140 |       0.000 |   -27255.140 |   -27255.140 |       0.000 |   -27255.140 |
| 2021 |    5 | MAY    | 123456 |   696 | 1234 | BMD  |        0.000 |     -39.500 |   -27294.640 |        0.000 |     -39.500 |   -27294.640 |
| 2022 |    1 | JAN    | 123456 |   696 | 1234 | BMD  |   -27255.140 |       0.000 |   -27255.140 |   -27255.140 |       0.000 |   -27255.140 |
| 2021 |    1 | JAN    | 123456 |   696 | 1234 | CAD  |    -2428.080 |       0.000 |    -2428.080 |    -3220.000 |       0.000 |    -3220.000 |
| 2021 |    4 | APR    | 123456 |   696 | 1234 | CAD  |        0.000 |  -16671.250 |   -19099.330 |        0.000 |  -20634.560 |   -23854.560 |
| 2021 |    6 | JUN    | 123456 |   696 | 1234 | CAD  |        0.000 |  -27757.730 |   -46857.060 |        0.000 |  -33660.000 |   -57514.560 |
| 2021 |    7 | JUL    | 123456 |   696 | 1234 | CAD  |        0.000 |  -13185.850 |   -60042.910 |        0.000 |  -16632.000 |   -74146.560 |
| 2022 |    1 | JAN    | 123456 |   696 | 1234 | CAD  |    -2428.080 |       0.000 |    -2428.080 |    -3220.000 |       0.000 |    -3220.000 |
| 2021 |    1 | JAN    | 123456 |   696 | 1234 | CHF  |  -220514.900 |       0.000 |  -220514.900 |  -210500.000 |       0.000 |  -210500.000 |
| 2021 |    2 | FEB    | 123456 |   696 | 1234 | CHF  |        0.000 |  -13370.400 |  -233885.300 |        0.000 |  -12000.000 |  -222500.000 |
| 2021 |    4 | APR    | 123456 |   696 | 1234 | CHF  |        0.000 |   -5417.500 |  -239302.800 |        0.000 |   -5000.000 |  -227500.000 |
| 2021 |    6 | JUN    | 123456 |   696 | 1234 | CHF  |        0.000 |  -84489.200 |  -323792.000 |        0.000 |  -76000.000 |  -303500.000 |
| 2021 |    7 | JUL    | 123456 |   696 | 1234 | CHF  |        0.000 |  -10898.000 |  -334690.000 |        0.000 |  -10000.000 |  -313500.000 |
| 2021 |    8 | AUG    | 123456 |   696 | 1234 | CHF  |        0.000 |  -34316.100 |  -369006.100 |        0.000 |  -31500.000 |  -345000.000 |
| 2022 |    1 | JAN    | 123456 |   696 | 1234 | CHF  |  -220514.900 |       0.000 |  -220514.900 |  -210500.000 |       0.000 |  -210500.000 |
| 2021 |    1 | JAN    | 123456 |   696 | 1234 | EUR  | -1213310.030 |       0.000 | -1213310.030 | -1084078.320 |       0.000 | -1084078.320 |
| 2021 |    1 | JAN    | 123456 |   696 | 1234 | EUR  |        0.000 |  -60065.090 | -1273375.120 |        0.000 |  -49407.820 | -1133486.140 |
| 2021 |    2 | FEB    | 123456 |   696 | 1234 | EUR  |        0.000 |  -60479.040 | -1333854.160 |        0.000 |  -49863.170 | -1183349.310 |
| 2021 |    3 | MAR    | 123456 |   696 | 1234 | EUR  |        0.000 |  -12680.530 | -1346534.690 |        0.000 |  -10630.000 | -1193979.310 |
| 2021 |    4 | APR    | 123456 |   696 | 1234 | EUR  |        0.000 | -147617.210 | -1494151.900 |        0.000 | -124488.790 | -1318468.100 |
| 2021 |    5 | MAY    | 123456 |   696 | 1234 | EUR  |        0.000 |  -60692.420 | -1554844.320 |        0.000 |  -49850.040 | -1368318.140 |
| 2021 |    6 | JUN    | 123456 |   696 | 1234 | EUR  |        0.000 |  -72969.800 | -1627814.120 |        0.000 |  -59846.750 | -1428164.890 |
| 2021 |    7 | JUL    | 123456 |   696 | 1234 | EUR  |        0.000 |  -67855.430 | -1695669.550 |        0.000 |  -57475.380 | -1485640.270 |
| 2021 |    8 | AUG    | 123456 |   696 | 1234 | EUR  |        0.000 |  -89161.800 | -1784831.350 |        0.000 |  -75624.430 | -1561264.700 |
| 2022 |    1 | JAN    | 123456 |   696 | 1234 | EUR  | -1213310.030 |       0.000 | -1213310.030 | -1084078.320 |       0.000 | -1084078.320 |
| 2021 |    1 | JAN    | 123456 |   696 | 1234 | GBP  | -2449684.590 |       0.000 | -2449684.590 | -1895760.520 |       0.000 | -1895760.520 |
| 2021 |    1 | JAN    | 123456 |   696 | 1234 | GBP  |        0.000 | -358602.930 | -2808287.520 |        0.000 | -263658.790 | -2159419.310 |
| 2021 |    2 | FEB    | 123456 |   696 | 1234 | GBP  |        0.000 | -342658.990 | -3150946.510 |        0.000 | -246690.900 | -2406110.210 |
| 2021 |    3 | MAR    | 123456 |   696 | 1234 | GBP  |        0.000 |  -24548.700 | -3175495.210 |        0.000 |  -17629.940 | -2423740.150 |
| 2021 |    4 | APR    | 123456 |   696 | 1234 | GBP  |        0.000 |  -22602.180 | -3198097.390 |        0.000 |  -16337.060 | -2440077.210 |
| 2021 |    5 | MAY    | 123456 |   696 | 1234 | GBP  |        0.000 | -408572.870 | -3606670.260 |        0.000 | -289051.220 | -2729128.430 |
| 2021 |    6 | JUN    | 123456 |   696 | 1234 | GBP  |        0.000 |  -81834.950 | -3688505.210 |        0.000 |  -58166.600 | -2787295.030 |
| 2021 |    7 | JUL    | 123456 |   696 | 1234 | GBP  |        0.000 | -656762.450 | -4345267.660 |        0.000 | -476738.700 | -3264033.730 |
| 2021 |    8 | AUG    | 123456 |   696 | 1234 | GBP  |        0.000 | -184405.370 | -4529673.030 |        0.000 | -134115.420 | -3398149.150 |
| 2022 |    1 | JAN    | 123456 |   696 | 1234 | GBP  | -2449684.590 |       0.000 | -2449684.590 | -1895760.520 |       0.000 | -1895760.520 |
| 2021 |    1 | JAN    | 123456 |   696 | 1234 | USD  |        0.000 |  426074.270 |   426074.270 |        0.000 |  426074.270 |   426074.270 |
| 2021 |    1 | JAN    | 123456 |   696 | 1234 | USD  |  8235414.760 |       0.000 |  8661489.030 |  8235414.760 |       0.000 |  8661489.030 |
| 2021 |    2 | FEB    | 123456 |   696 | 1234 | USD  |        0.000 |  466995.850 |  9128484.880 |        0.000 |  466995.850 |  9128484.880 |
| 2021 |    3 | MAR    | 123456 |   696 | 1234 | USD  |        0.000 |   42436.370 |  9170921.250 |        0.000 |   42436.370 |  9170921.250 |
| 2021 |    4 | APR    | 123456 |   696 | 1234 | USD  |        0.000 |  211274.660 |  9382195.910 |        0.000 |  211274.660 |  9382195.910 |
| 2021 |    5 | MAY    | 123456 |   696 | 1234 | USD  |        0.000 |  467332.520 |  9849528.430 |        0.000 |  467332.520 |  9849528.430 |
| 2021 |    6 | JUN    | 123456 |   696 | 1234 | USD  |        0.000 |  324603.360 | 10174131.790 |        0.000 |  324603.360 | 10174131.790 |
| 2021 |    7 | JUL    | 123456 |   696 | 1234 | USD  |        0.000 |  908661.630 | 11082793.420 |        0.000 |  908661.630 | 11082793.420 |
| 2021 |    8 | AUG    | 123456 |   696 | 1234 | USD  |        0.000 |  523337.300 | 11606130.720 |        0.000 |  523337.300 | 11606130.720 |
| 2022 |    1 | JAN    | 123456 |   696 | 1234 | USD  |  8235414.760 |       0.000 |  8235414.760 |  8235414.760 |       0.000 |  8235414.760 |
| 2021 |    1 | JAN    | 123456 | 20698 | 1234 | USD  | -3162799.570 |       0.000 | -3162799.570 | -3162799.570 |       0.000 | -3162799.570 |
| 2021 |    1 | JAN    | 123456 | 20698 | 1234 | USD  |        0.000 |   -7406.250 | -3170205.820 |        0.000 |   -7406.250 | -3170205.820 |
| 2021 |    2 | FEB    | 123456 | 20698 | 1234 | USD  |        0.000 |  -50487.420 | -3220693.240 |        0.000 |  -50487.420 | -3220693.240 |
| 2021 |    3 | MAR    | 123456 | 20698 | 1234 | USD  |        0.000 |   -4525.400 | -3225218.640 |        0.000 |   -4525.400 | -3225218.640 |
| 2021 |    4 | APR    | 123456 | 20698 | 1234 | USD  |        0.000 |   -1927.850 | -3227146.490 |        0.000 |   -1927.850 | -3227146.490 |
| 2021 |    6 | JUN    | 123456 | 20698 | 1234 | USD  |        0.000 |  -55464.080 | -3282610.570 |        0.000 |  -55464.080 | -3282610.570 |
| 2021 |    7 | JUL    | 123456 | 20698 | 1234 | USD  |        0.000 | -143506.760 | -3426117.330 |        0.000 | -143506.760 | -3426117.330 |
| 2021 |    8 | AUG    | 123456 | 20698 | 1234 | USD  |        0.000 | -142850.050 | -3568967.380 |        0.000 | -142850.050 | -3568967.380 |
| 2022 |    1 | JAN    | 123456 | 20698 | 1234 | USD  | -3162799.570 |       0.000 | -3162799.570 | -3162799.570 |       0.000 | -3162799.570 |
| 2021 |    1 | JAN    | 123456 | 20701 | 1234 | USD  |    -8538.750 |       0.000 |    -8538.750 |    -8538.750 |       0.000 |    -8538.750 |
| 2021 |    3 | MAR    | 123456 | 20701 | 1234 | USD  |        0.000 |    -681.740 |    -9220.490 |        0.000 |    -681.740 |    -9220.490 |
| 2022 |    1 | JAN    | 123456 | 20701 | 1234 | USD  |    -8538.750 |       0.000 |    -8538.750 |    -8538.750 |       0.000 |    -8538.750 |
| 2021 |    1 | JAN    | 123456 | 20706 | 1234 | CAD  |    -9189.700 |       0.000 |    -9189.700 |   -12000.000 |       0.000 |   -12000.000 |
| 2022 |    1 | JAN    | 123456 | 20706 | 1234 | CAD  |    -9189.700 |       0.000 |    -9189.700 |   -12000.000 |       0.000 |   -12000.000 |
 ------ ------ -------- -------- ------- ------ ------ -------------- ------------- -------------- -------------- ------------- --------------

轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/406833.html

標籤：

上一篇：相同復合鍵的固定值

下一篇：我正在嘗試使用SQL獲取兩個欄位的差異

標籤雲
其他(157675) Python(38076) JavaScript(25376) Java(17977) C(15215) 區塊鏈(8255) C＃(7972) AI(7469) 爪哇(7425) MySQL(7132) html(6777) 基礎類(6313) sql(6102) 熊猫(6058) PHP(5869) 数组(5741) R(5409) Linux(5327) 反应(5209) 腳本語言(PerlPython)(5129) 非技術區(4971) Android(4554) 数据框(4311) css(4259) 节点.js(4032) C語言(3288) json(3245) 列表(3129) 扑(3119) C++語言(3117) 安卓(2998) 打字稿(2995) VBA(2789) Java相關(2746) 疑難問題(2699) 细绳(2522) 單片機工控(2479) iOS(2429) ASP.NET(2402) MongoDB(2323) 麻木的(2285) 正则表达式(2254) 字典(2211) 循环(2198) 迅速(2185) 擅长(2169) 镖(2155) 功能(1967) .NET技术(1958) Web開發(1951) python-3.x(1918) HtmlCss(1915) 弹簧靴(1913) C++(1909) xml(1889) PostgreSQL(1872) .NETCore(1853) 谷歌表格(1846) Unity3D(1843) for循环(1842)

熱門瀏覽
  • CA和證書

    1、在 CentOS7 中使用 gpg 創建 RSA 非對稱密鑰對 gpg --gen-key #Centos上生成公鑰/密鑰對（存放在家目錄.gnupg/） 2、將 CentOS7 匯出的公鑰，拷貝到 CentOS8 中，在 CentOS8 中使用 CentOS7 的公鑰加密一個檔案 gpg -a ......

    uj5u.com 2020-09-10 00:09:53 more
  • Kubernetes K8S之資源控制器Job和CronJob詳解

    Kubernetes的資源控制器Job和CronJob詳解與示例 ......

    uj5u.com 2020-09-10 00:10:45 more
  • VMware下安裝CentOS

    VMware下安裝CentOS 一、軟硬體準備 1 Centos鏡像準備 1.1 CentOS鏡像下載地址 下載地址 1.2 CentOS鏡像下載程序 點擊下載地址進入如下圖的網站，選擇需要下載的版本，這里選擇的是Centos8，點擊如圖所示。 決定選擇Centos8后，選擇想要的鏡像源進行下載，此 ......

    uj5u.com 2020-09-10 00:12:10 more
  • 如何使用Grep命令查找多個字串

    如何使用Grep 命令查找多個字串 大家好，我是良許！ 今天向大家介紹一個非常有用的技巧，那就是使用 grep 命令查找多個字串。 簡單介紹一下，grep 命令可以理解為是一個功能強大的命令列工具，可以用它在一個或多個輸入檔案中搜索與正則運算式相匹配的文本，然后再將每個匹配的文本用標準輸出的格式 ......

    uj5u.com 2020-09-10 00:12:28 more
  • git配置http代理

    git配置http代理 經常遇到克隆 github 慢的問題，這里記錄一下幾種配置 git 代理的方法，解決 clone github 過慢。 目錄 git配置代理 git單獨配置github代理 git配置全域代理 配置終端環境變數 git配置代理 主要使用 git config 命令 git單獨 ......

    uj5u.com 2020-09-10 00:12:33 more
  • Linux npm install 裝包時提示Error EACCES permission denied解

    npm install 裝包時提示Error EACCES permission denied解決辦法 ......

    uj5u.com 2020-09-10 00:12:53 more
  • Centos 7下安裝nginx，使用yum install nginx，提示沒有可用的軟體包

    Centos 7下安裝nginx，使用yum install nginx，提示沒有可用的軟體包。 18 (flaskApi) [root@67 flaskDemo]# yum -y install nginx 19 已加載插件：fastestmirror, langpacks 20 Loading ......

    uj5u.com 2020-09-10 00:13:13 more
  • Linux查看服務器暴力破解ssh IP

    在公網的服務器上經常遇到別人爆破你服務器的22埠，用來挖礦或者干其他嘿嘿嘿的事情~ 這種情況下正確的做法是： 修改默認ssh的22埠 使用設定密鑰登錄或者白名單ip登錄 建議服務器密碼為復雜密碼 創建普通用戶登錄服務器（root權限過大） 建立堡壘機，實作統一管理服務器 統計爆破IP [root ......

    uj5u.com 2020-09-10 00:13:17 more
  • CentOS 7系統常見快捷鍵操作方式

    Linux系統中一些常見的快捷方式，可有效提高操作效率，在某些時刻也能避免操作失誤帶來的問題。 ......

    uj5u.com 2020-09-10 00:13:31 more
  • CentOS 7作業系統目錄結構介紹

    作業系統存在著大量的資料檔案資訊，相應檔案資訊會存在于系統相應目錄中，為了更好的管理資料資訊，會將系統進行一些目錄規劃，不同目錄存放不同的資源。 ......

    uj5u.com 2020-09-10 00:13:35 more
最新发布
  • vim的常用命令

    Vim的6種基本模式 1. 普通模式在普通模式中，用的編輯器命令，比如移動游標，洗掉文本等等。這也是Vim啟動后的默認模式。這正好和許多新用戶期待的操作方式相反（大多數編輯器默認模式為插入模式）。 2. 插入模式在這個模式中，大多數按鍵都會向文本緩沖中插入文本。大多數新用戶希望文本編輯器編輯程序中一 ......

    uj5u.com 2023-04-20 08:43:21 more
  • vim的常用命令

    Vim的6種基本模式 1. 普通模式在普通模式中，用的編輯器命令，比如移動游標，洗掉文本等等。這也是Vim啟動后的默認模式。這正好和許多新用戶期待的操作方式相反（大多數編輯器默認模式為插入模式）。 2. 插入模式在這個模式中，大多數按鍵都會向文本緩沖中插入文本。大多數新用戶希望文本編輯器編輯程序中一 ......

    uj5u.com 2023-04-20 08:42:36 more
  • docker學習

    ###Docker概述 真實專案部署環境可能非常復雜，傳統發布專案一個只需要一個jar包，運行環境需要單獨部署。而通過Docker可將jar包和相關環境（如jdk，redis，Hadoop...）等打包到docker鏡像里，將鏡像發布到Docker倉庫，部署時下載發布的鏡像，直接運行發布的鏡像即可。 ......

    uj5u.com 2023-04-19 09:26:53 more
  • 設定Windows主機的瀏覽器為wls2的默認瀏覽器

    這里以Chrome為例。 1. 準備作業 wsl是可以使用Windows主機上安裝的exe程式，出于安全考慮，默認情況下改功能是無法使用。要使用的話，終端需要以管理員權限啟動。 我這里以Windows Terminal為例，介紹如何默認使用管理員權限打開終端，具體操作如下圖所示： 2. 操作 wsl ......

    uj5u.com 2023-04-19 09:25:49 more
  • docker學習

    ###Docker概述 真實專案部署環境可能非常復雜，傳統發布專案一個只需要一個jar包，運行環境需要單獨部署。而通過Docker可將jar包和相關環境（如jdk，redis，Hadoop...）等打包到docker鏡像里，將鏡像發布到Docker倉庫，部署時下載發布的鏡像，直接運行發布的鏡像即可。 ......

    uj5u.com 2023-04-19 09:19:04 more
  • Linux學習筆記

    IP地址和主機名 IP地址 ifconfig可以用來查詢本機的IP地址，如果不能使用，可以通過install net-tools安裝。 Centos系統下ens33表示主網卡；inet后表示IP地址；lo表示本地回環網卡； 127.0.0.1表示代指本機；0.0.0.0可以用于代指本機，同時在放行設 ......

    uj5u.com 2023-04-18 06:52:01 more
  • 解決linux系統的kdump服務無法啟動的問題

    問題：專案麒麟系統服務器的kdump服務無法啟動，沒有相關日志無法定位問題。 1、查看服務狀態是關閉的，重啟系統也無法啟動 systemctl status kdump 2、修改grub引數，修改“crashkernel”為“512M（有的機器數值太大太小都會導致報錯，建議從128M開始試，或者加個 ......

    uj5u.com 2023-04-12 09:59:50 more
  • 解決linux系統的kdump服務無法啟動的問題

    問題：專案麒麟系統服務器的kdump服務無法啟動，沒有相關日志無法定位問題。 1、查看服務狀態是關閉的，重啟系統也無法啟動 systemctl status kdump 2、修改grub引數，修改“crashkernel”為“512M（有的機器數值太大太小都會導致報錯，建議從128M開始試，或者加個 ......

    uj5u.com 2023-04-12 09:59:01 more
  • 你是不是暴露了？

    作者：袁首京 原創文章，轉載時請保留此宣告，并給出原文連接。 如果您是計算機相關從業人員，那么應該經歷不止一次網路安全專項檢查了，你肯定是收到過資訊系統技術檢測報告，要求你加強風險監測，確保你提供的系統服務堅實可靠了。 沒檢測到問題還好，檢測到問題的話，有些處理起來還是挺麻煩的，尤其是線上正在運行的 ......

    uj5u.com 2023-04-05 16:52:56 more
  • 細節拉滿，80 張圖帶你一步一步推演 slab 記憶體池的設計與實作

    1. 前文回顧 在之前的幾篇記憶體管理系列文章中，筆者帶大家從宏觀角度完整地梳理了一遍 Linux 記憶體分配的整個鏈路，本文的主題依然是記憶體分配，這一次我們會從微觀的角度來探秘一下 Linux 內核中用于零散小記憶體塊分配的記憶體池 —— slab 分配器。 在本小節中，筆者還是按照以往的風格先帶大家簡單 ......

    uj5u.com 2023-04-05 16:44:11 more

Copyright © 2010-2020 有解無憂