About Us

Learn more about us.

Dynamics GP

A Microsoft Dynamics GP table reference was created to help users create SQL queries.

Read More

Lesson Plans

Lesson plans created by certified members of the Ontario College of Teachers.

Read More

Service Pricing

Learn about Datacrunch Canada services and competitive rates.

Read More

Sample SQL Test

Sample SQL Server Test Q = Question A = Answer C = Comments Q1. What does SQL Stand for? A1. Structured Query Language C1. This question was probably asked to weed out candidates who answer “Sequel” or guess. Q2. Write a SQL query to select everything in a table. A2. SELECT * FROM <table> C2.

Read More

Jamaican Stew Chicken Recipe

Ingredients Chicken Grace Browning Caramel Sauce West Indian All-Purpose Seasoning Soy Sauce Onions and Garlic or Garlic Powder Oregano Black Pepper Instructions Add all ingredients in teaspoon amounts Sear the chicken in very hot oil Throw away excess oil when done Add two cups water, along with onion and diced garlic and more All-Purpose Seasoning

Read More

slide_01

Basic T-SQL Join Where…

Lets say you have two tables: Employees and Profile.  You need to find everyone who is over 21. Employees: UserID, int Name, varchar(5) 1, Peter 2, Cathy 3, Manuel 4, Jonathan Profile: UserID, int Birthday, date 1, 2010-03-13 2, 1997-06-21 3, 1988-04-16 4, 2013-08-22 select Name from Employees as e join Profile as p on e.UserId=p.UserID where DATEADD(YY,21,Birthday) <

Read More

ff7re_01

FFVII: Re-Imagined

Head over to http://ffvii-reimagined.com to download the game. Feels like playing Megaman with Zero.  Wasn’t able to get it working with my PS3 controller though.  Default keyboard mapping is awkward for a side-scroller.  Looking forward to the completed game!