Parse a String in SQL and Return Data After Last Occurrence
I have a string value in a column in my table. It’s a full path and filename for a .tif image. I needed to get just the filename as a column. I couldn’t use a […]
Month: October 2014
States / Provinces Lookup Table
I recently needed a lookup table of all 50 US states (and Washington DC) and the provinces / territories in Canada. The script below will create a table (tbl_LUState) and will populate the table with […]
NetTrax Removable Media Audit
We are working on a special project for an existing client. We’ll be scanning hundreds of thousands of documents over the next year to year and a half. The delivery of the digital images will […]