Using PIVOT on Dates in One Column

Suppose you have a table that contains Job ID, when it was started, and when the Job ended. Now you want the difference in days between when it was started and when it ended. You can use the PIVOT command in SQL. From there you can then derive the difference in days, hours, minutes or any combination. Learn More

Tags: , , , , , , , , , , , , , , , | Posted under Programming/Coding | Leave a comment

Block Specific TomatoCart Users Based on Area or IP Address

For some reason, you may need to block some specific users from accessing your store. It is possible to do that with the following service module – Block Users in this article.

Features: Learn More

Tags: , , , , , , , , , , , , , , , | Posted under TomatoCart | 2 Comments

Zurmo – Creating a New Project

You’ve come across a new business Project and want to document the details in Zurmo so you can record all of the information and progress on the new Project. Zurmo makes it very easy to navigate establishing a new Project. Let’s get started!

The first step is to make sure you are on your Zurmo Dashboard. By selecting the Home button you will be situated on your Zurmo Dashboard. Learn More

Tags: , , , , , | Posted under Zurmo | Leave a comment