admin管理员组文章数量:1333427
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.
本文标签:
版权声明:本文标题:Invalid object name 'dbo.uspEnvelopeBudgetTransactionsBalanceQuery' error from a Sql Server stored procedure - S 内容由网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:http://www.betaflare.com/web/1742307068a2450129.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论