Found a great article at www.simple-talk.com which described how to create pivot queries with dynamic column names. It seems simple at first until you try to adjust your columns manually and then discover that you really need to implement some special code to accomplish the task. The article Pivots with Dynamic Columns in SQL Server 2005 provides just the right information to … Read More
Some more command line fun – sending email
After all the work I did with the dates in the environment variable I had a need to email the files I was working with. Found a really GREAT command line utility that allows for sending email from a batch file. It has nearly endless options and took about 2 minutes to setup and get working in our environment. It’s … Read More
Need to make screen captures for documentation?
I have been tired of trying to copy and paste sections of the screen for all the documentation that needs to be written for our software solutions. The solution we have come up with is to use a great product from TechSmith called SnagIt. It provides a simple way to easily capture portions of the screen or windows and then … Read More