JSFiddle - React, Tailwind, and code Playground

by ktabarez

JavaScript

declare @payAmt decimal
		,@firstpaydayoftheyear datetime
		,@nextpayday datetime
		,@lastdateoftheyear datetime
		,@remainingMonthsInYear int
		,@remainingearnings decimal
		,@estimateTaxReturn decimal

declare @payDays as table
(
	payday datetime
	,amount decimal
)

declare @bills as table
(
	name varchar(500)
	,dayDue varchar(10)
	,amountdue decimal
)

/***********************MODIFY START***********************/
select @payAmt = 1880
	,@firstpaydayoftheyear = '01/010/2014'
	,@nextpayday = '08/08/2014'
	,@estimateTaxReturn = 7000

insert into @bills values('rent', '5', 995)
insert into @bills values('school', '11', 285)
insert into @bills values('cox', '11', 70)
insert into @bills values('gas', '5', 180)
insert into @bills values('healthyfam', '5', 12)
insert into @bills values('aaa', '5', 70)
insert into @bills values('sdge', '5', 40)
insert into @bills values('food', '5', 200)
insert into @bills values('entertainment', '5', 100)
/***********************MODIFY END*************************/

select @remainingMonthsInYear = DATEDIFF(month, @nextpayday, DATEADD(yy, DATEDIFF(yy,0,@nextpayday) + 1, 0)) --http://stackoverflow.com/questions/13437362/how-to-get-first-and-last-date-of-current-year
	,@lastdateoftheyear = DATEADD(yy, DATEDIFF(yy,0,@firstpaydayoftheyear) + 1, -1)

insert into @payDays select DATEADD(day,14, @firstpaydayoftheyear), @payAmt
insert into @payDays select DATEADD(day,14, DATEADD(day,14, @firstpaydayoftheyear)), @payAmt
insert into @payDays select DATEADD(day,14, DATEADD(day,14, DATEADD(day,14, @firstpaydayoftheyear))), @payAmt
insert into @payDays select DATEADD(day,14, DATEADD(day,14, DATEADD(day,14, DATEADD(day,14, @firstpaydayoftheyear)))), @payAmt
insert into @payDays select DATEADD(day,14, DATEADD(day,14, DATEADD(day,14, DATEADD(day,14, DATEADD(day,14, @firstpaydayoftheyear))))), @payAmt
insert into @payDays select DATEADD(day,14, DATEADD(day,14, DATEADD(day,14, DATEADD(day,14, DATEADD(day,14, DATEADD(day,14, @firstpaydayoftheyear)))))),...