When I Execute the following, I get the error.
ALTER PROCEDURE \[dbo\].\[uspEnvelopeBudgetTransactionsBalanceQuery2\]
AS BEGIN
SET NOCOUNT ON; SELECT * , (SELECT SUM(T2.[SumOfAmount]) FROM dbo.uspEnvelopeBudgetTransactionsBalanceQuery AS T2 WHERE T2.[PayDate] <= T1.[PayDate]) AS Balance FROM dbo.uspEnvelopeBudgetTransactionsBalanceQuery AS T1;
I tried to get it to run by delete dbo. and usp from EnvelopeBudgetTransactionsQuery.I tried dropping it and recreating it.
What is want is a running total of SumOfAmount in by PayDate. I am migrating the backend of an Access database to Sql Server and I am new to Sql Server.
发布者：admin，转转请注明出处：http://www.yc00.com/questions/1742307069a4419152.html
评论列表（0条）