Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Insert statements for dbo.RunningTotals
INSERT INTO dbo.RunningTotals (SpentDate, SpentAmount) VALUES (DATEADD(DAY, -1, GETDATE()), 50.00);
INSERT INTO dbo.RunningTotals (SpentDate, SpentAmount) VALUES (DATEADD(DAY, -1, GETDATE()), 50.00);
INSERT INTO dbo.RunningTotals (SpentDate, SpentAmount) VALUES (DATEADD(DAY, -1, GETDATE()), -75.00);
INSERT INTO dbo.RunningTotals (SpentDate, SpentAmount) VALUES (DATEADD(DAY, -1, GETDATE()), 50.00);
INSERT INTO dbo.RunningTotals (SpentDate, SpentAmount) VALUES (GETDATE(), 100.00);
INSERT INTO dbo.RunningTotals (SpentDate, SpentAmount) VALUES (GETDATE(), 100.00);
INSERT INTO dbo.RunningTotals (SpentDate, SpentAmount) VALUES (GETDATE(), -150.00);
INSERT INTO dbo.RunningTotals (SpentDate, SpentAmount) VALUES (GETDATE(), 100.00);
SELECT * FROM dbo.RunningTotals;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment