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 […]
Category: Database
Database technologies and vendors.
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 […]
Checklist to allow remote connection to SQL Server
Every time I setup a new SQL Server I always forget one or more of the steps below to allow remote connection from another workstation via SSMS. 1. SQL Server Properties: check “Allow remote […]
How to Avoid Errors When Importing to Access Database
I had a spreadsheet that was in .xlsx format that I needed to import into an Access Database. I made sure the columns were in the correct order, and that the column headers matched my […]
Renaming a SQL Server database’s logical name
At times we copy a SQL Server database from one database name to another for testing or development. One thing that doesn’t change is the logical name: Using the following SQL script the logical name […]
Keyword searching using Full-Text Indexing (Getting Started)
Creating a full-text catalog in SQL Server is easy, I used a tutorial on one of our favorite SQL Server blogs: http://blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/ I created 4 catalogs: Each catalog is assigned to a table and columns […]
SQL Server Reporting Services – SMTP Authentication Workaround
We at Bradford use Google Apps for our email. My computer not part of the domain (I don’t’ work from the corporate office) and we don’t have our own internal SMTP server in our domain […]
Finding the average number of documents in folders
I found an example that used syntax where I could find the average based on a group count. In this case, the group by is the folder’s tracking id (ParentTracking_ID) assigned to the document. SELECT […]
Import Format Macro Example: Creating Drop Down (Lookup) Entries
Scenario: a drop-down (lookup) key-value along with the description are included in an import file. There are data scenarios were in the drop-down (lookup) table: 1) The key (code) already exists and we would use […]
How to Loop Through Audit Records
Recently I needed a way to essentially ‘loop’ through all the records in our NetTrax.NET Audit History for the given record and return back the one that is that entries ‘check in’… So, what I […]