Author: David Kittell

–FOR SQL SERVER 2000: –FOR SQL SERVER 2005: Source: http://blog.sqlauthority.com/2007/04/24/sql-server-trim-function-udf-trim/

Error: Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation. When you run into this error simply add “COLLATE Latin1_General_CI_AS” after the column name(s) that you are selecting or comparing and it will work.

Source: http://blog.sqlauthority.com/2007/05/13/sql-server-query-to-find-first-and-last-day-of-current-month/ http://blog.sqlauthority.com/2007/08/18/sql-server-find-last-day-of-any-month-current-previous-next/