Archive for September, 2007

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 generate output in a multitude of formats (graphics, PDF, Word, Excel, etc, etc, etc).

If anyone knows of a better tools than SnagIt, let us know.

Found a great tip online on how to create a date in T-SQL in a very fast way.  The code looks like this:

declare @year int, @month int, @day int
select @year = 2006, @month = 1, @day = 16

select dateadd(month,((@Year-1900)*12)+@Month-1,@Day-1)

This is especially useful when doing date comparisons in queries.  Many people use the convert function, but the above code executes far faster because it does not have to do any string manipulations.  Credit should be given to Michael Valentine Jones for this tip.  More information about this tip can be found here.  Here is some more great information on date manipulation for SQL Server.