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...
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...
Say hello to Cavanto, this is a new Men’s shirt brand I’m launching as a grand experiment. Cavanto is a high quality dress shirt for the business executive.
I know, I know. You are saying….”WTF...
Communicating the company’s strategy to the organization is a difficult thing to do. Everyone has to buy into the goal of where the company is headed and being able to clearly articulate the...
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...
I previously shared how to clean out the junk from Launchpad that is auto populated in one swoop – back to nothing. In the following months though, clutter has again entered the space and rapidly...