Skip to content

Instantly share code, notes, and snippets.

View davghouse's full-sized avatar

David Galehouse davghouse

View GitHub Profile
@davghouse
davghouse / RussianWordamentSolverExample.cs
Created February 25, 2018 20:17
Russian Wordament Solver example
[TestMethod]
public void RussianSolutionExample()
{
// This dictionary is incomplete.
var russianDictionary = new[]
{
"АВТОМОБИЛЬ",
"СОБАКА",
"САМОЛЕТ",
"КОСМОНАВТ",
@davghouse
davghouse / CopyNationUnrootedWorld.sql
Created February 11, 2017 01:09
Copy Nation procedure for Unrooted World database
CREATE PROCEDURE [dbo].[CopyNation]
@id INT
AS
BEGIN
SET NOCOUNT ON;
SET XACT_ABORT ON;
BEGIN TRAN;
DECLARE @NationIDPairs TABLE (
ExistingID INT NOT NULL UNIQUE,
@davghouse
davghouse / CopyProvinceRootedWorld.sql
Created February 11, 2017 00:49
Copy Province procedure for Rooted World database
CREATE PROCEDURE [dbo].[CopyProvince]
@id INT
AS
BEGIN
SET NOCOUNT ON;
SET XACT_ABORT ON;
BEGIN TRAN;
DECLARE @ProvinceIDPairs TABLE (
ExistingID INT NOT NULL UNIQUE,
@davghouse
davghouse / CopyNationRootedWorld.sql
Created February 11, 2017 00:34
Copy Nation procedure for Rooted World database
CREATE PROCEDURE [dbo].[CopyNation]
@id INT
AS
BEGIN
SET NOCOUNT ON;
SET XACT_ABORT ON;
BEGIN TRAN;
DECLARE @NationIDPairs TABLE (
ExistingID INT NOT NULL UNIQUE,