14-03-2018, Saat: 00:10
(Son Düzenleme: 15-03-2018, Saat: 15:52, Düzenleyen: adelphiforumz.)
2012 ve üstü versiyonlar için
CREATE TABLE [dbo].[Test]( [Id] [int] NOT NULL, [Kod] [nvarchar](5) NULL, [Tarih] [datetime] NULL, [Tip] [nvarchar](1) NULL, [Tutar] [decimal](15, 2) NULL, CONSTRAINT [PK_Test] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO INSERT [dbo].[Test] ([Id], [Kod], [Tarih], [Tip], [Tutar]) VALUES (1, N'k01', CAST(0x0000A87A00000000 AS DateTime), N'G', CAST(50.00 AS Decimal(15, 2))) INSERT [dbo].[Test] ([Id], [Kod], [Tarih], [Tip], [Tutar]) VALUES (2, N'k01', CAST(0x0000A87D00000000 AS DateTime), N'C', CAST(2.00 AS Decimal(15, 2))) INSERT [dbo].[Test] ([Id], [Kod], [Tarih], [Tip], [Tutar]) VALUES (3, N'k01', CAST(0x0000A87D00000000 AS DateTime), N'C', CAST(4.00 AS Decimal(15, 2))) INSERT [dbo].[Test] ([Id], [Kod], [Tarih], [Tip], [Tutar]) VALUES (4, N'k02', CAST(0x0000A87F00000000 AS DateTime), N'G', CAST(32.00 AS Decimal(15, 2))) INSERT [dbo].[Test] ([Id], [Kod], [Tarih], [Tip], [Tutar]) VALUES (5, N'k01', CAST(0x0000A89800000000 AS DateTime), N'G', CAST(15.00 AS Decimal(15, 2))) INSERT [dbo].[Test] ([Id], [Kod], [Tarih], [Tip], [Tutar]) VALUES (6, N'k02', CAST(0x0000A89800000000 AS DateTime), N'C', CAST(7.00 AS Decimal(15, 2))) INSERT [dbo].[Test] ([Id], [Kod], [Tarih], [Tip], [Tutar]) VALUES (7, N'k01', CAST(0x0000A89900000000 AS DateTime), N'C', CAST(25.00 AS Decimal(15, 2))) go select Kod, Tarih, Giris, Cikis, Sum(Tutar) over(order by kod, Tarih, Id) as Toplam From (Select Id, Kod, Tarih, Tip, Case When Tip = 'G' Then Tutar Else 0 End Giris, Case When Tip = 'C' Then Tutar Else 0 End Cikis, Case When Tip = 'G' Then Tutar Else Tutar*-1 End Tutar From Test) Tmp Order By Kod, Tarih, Id go
Bu dünyada kendine sakladığın bilgi ahirette işine yaramaz.