apeterson-BFI

            // y - 1000s
            // x - 1s
            // [900 : 999] - working memory
            // 900 - x direction
            // 901 - y direction
            // 902 - y * 1000
            // 903 - x + y * 1000
            // 910 - paint color
            // 911 - turn command (0 turn left) (1 turn right)
            // 920 - comparison storage

apeterson-BFI

1,0
2,0
3,0
4,0
5,0
6,0
7,0
8,0
9,0
10,0

apeterson-BFI

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace AdventCSharp
{
    public class CircularLinkListNode
    {

apeterson-BFI

namespace AdventOfCode

module Day6 =
    open System
    open System.IO
    open System.Text
    open System.Text.RegularExpressions
    open Utils
    open System.Collections.Generic
    open System.Linq

apeterson-BFI

namespace AdventOfCode

module Day5 =
    open System
    open System.IO
    open System.Text
    open System.Text.RegularExpressions
    open Utils
    open System.Collections.Generic
    open System.Linq

apeterson-BFI

module Day4 =
    open Day1
    open Day2
    open Day3
    open System.IO
    open System.Text
    open System.Text.RegularExpressions
    open Utils
    open System.Collections.Generic
    open System.Linq

apeterson-BFI

ALTER PROCEDURE VoidCheckProcedure
@checkID int
AS
BEGIN
	BEGIN TRANSACTION;

		BEGIN TRY

			/* update status of Orig Check to V */
			UPDATE [Check] SET [Status] = 'V' WHERE Check_ID = @checkID;

apeterson-BFI

	/* update Receipts on Check to O, X, or V */
	UPDATE r1
	SET [Status] =
		CASE 
			WHEN MaxSeq.MaxSeqNo % 2 = 1 THEN			-- ends in a void
				CASE r1.SequenceNo
					WHEN MaxSeq.MaxSeqNo THEN 'V'
					WHEN MaxSeq.MaxSeqNo - 1 THEN 'V'
					ELSE 'X'
				END

apeterson-BFI

apeterson-BFI