First, thanks to Hipster Ipsum for providing really fun random string data! I created a proc this week that was a simple SELECT ALL from a lookup and the output was going to be used in a drop down menu in a Reporting Services report. The data wasn’t the prettiest and I wanted to capitalize [...]
One area I’ve always felt MSSQL was lacking is handling dates. This week I needed to declare a date variable and select the beginning of the previous hour. I cobbled together a solution that I thought would be useful to add to the blogosphere. Below is a screenshot and the code you can copy and [...]
Neat trick that Lee Ervin showed me:
There are oodles of solutions to this problem out there, but this is one I hacked together when I needed a quick solution. Say you have a varchar parameter containing a comma separated list of integers e.g. ’101,102, … ‘ that you need inserted to a table. This script will do that pretty quickly, with [...]