mirror of
https://github.com/acedanger/budget-database.git
synced 2025-12-05 22:50:13 -08:00
8 lines
178 B
Transact-SQL
8 lines
178 B
Transact-SQL
use Leo
|
|
go
|
|
|
|
alter view dbo.vw_CurrentMonthBudget
|
|
as
|
|
select *
|
|
from dbo.vw_BudgetRunningBalance
|
|
where TrxDate between dateadd(DAY, 1, EOMONTH(getDate(), -1)) and eomonth(getDate()) |