Author: ndconsultingllc

Posted on: September 22, 2020 Posted by: ndconsultingllc Comments: 0

SQL GOTO

USE SQL’S GOTO TO BOUNCE AROUND A STORED PROCEDURE While working on a recent project, I found SQL Server’s GOTO label to skip sections of code that you don’t want…

Posted on: September 8, 2020 Posted by: ndconsultingllc Comments: 0

Excel: Sort Column By Color

Sorting in Excel is a pretty simple #techtip, but thought I would share since several clients did not know Excel allows sorting by cell color. Use case: You have a…

Posted on: August 14, 2020 Posted by: ndconsultingllc Comments: 0

Robust Search Tool

Have you ever been looking for a file but cannot remember where you saved it in the thousands of folders on your laptop? After wasting a lot of time searching…

Posted on: July 30, 2020 Posted by: ndconsultingllc Comments: 0

NotePad++ – Macros

Macros – Repeating the same behavior on each row I’ve been using NotePad++ for many, many moons. I found it to be one of the best text editors out there…