Category: <span>Binary</span>

Setting Up OpenERP on Amazon EC2

Written by Gregory on March 31, 2013. Posted in Binary. 2 Comments on Setting Up OpenERP on Amazon EC2

Initial perusals of OpenERP 7 appeared to be quite impressive and offering a robust ERP package for small business. Here are the simple steps to test this out further using Amazon’s AWS cloud...

Forcing Excel to Recalculate

Written by Gregory on December 2, 2012. Posted in Binary, Excel Skills.

Occasionally your computer might run out of RAM, or Excel could just get bogged down because you have too much open and things just start to not calculate properly. Sometimes everything is working...

SQL Previous Business Day Function

Written by Gregory on October 18, 2012. Posted in Binary, Financial Models.

This is a simple function for MS SQL that can make reporting so much easier by finding the previous business day. Setup the function: CREATE FUNCTION [dbo].[fn_prevbusday](@date DATETIME) RETURNSDATETIMEAS BEGIN DECLARE...

Edit a Magento Configurable Product

Written by Gregory on August 20, 2012. Posted in Binary.

Magento does not allow you to edit a configurable product once it has been created in order to add a new attribute to the product. This is quite annoying since ‘stuff comes up’ where this...

Searching within a Stored Procedure

Written by Gregory on May 15, 2012. Posted in Binary.

Handy bit of code to search all of the stored procedures at one time: SELECT Name FROM sys.procedures WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE ‘%customer%’ GO This will return the stored...

Your Own URL Shortener

Setting Up OpenERP on Amazon EC2

Forcing Excel to Recalculate

SQL Previous Business Day Function

Edit a Magento Configurable Product

Searching within a Stored Procedure