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