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/
Category: Code
This area of the site is dedicated to code snippets for quick and easy reference
Subscribed Web Alert
Will return you all the web alerts. The ID column represent the ID for the web alert Will return you the folder(s) where the web alert is assigned The column Value_number represents the ID column from subscriptions_tbl The column Object_ID represents the folder ID where the web alert is assigned…
Format US Phone
Worst case scenario, for when you do not have the ability to do Regex replace. I have modified the code from the source link below to account for incorrect/invalid phone numbers. The original code will display NULL if the phone number is not valid where my edit will show the…
Regex Match
Source: https://www.simple-talk.com/sql/t-sql-programming/tsql-regular-expression-workbench/
Regex Replace
Source: https://www.simple-talk.com/sql/t-sql-programming/tsql-regular-expression-workbench/
Drop Function If Exists
Source: https://www.simple-talk.com/sql/t-sql-programming/tsql-regular-expression-workbench/
Proper Case Function
This will convert a given string to proper case. Source: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47718