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 […]
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 […]
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 […]
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 […]
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 […]
By Microsoft’s definition, Shared.: “Specifies that one or more declared programming elements are associated with a class or structure at large, and not with a specific instance of the class or structure.” Source What does […]
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 […]
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 […]
Often we send a database to a client and then later on find out that a key got dropped or an index removed along the way… Well, now we can easily test this! Open up […]
We frequently have to generate location or item codes for clients. This is typically a sequential number that has multiple levels in the code. For example, there are 4 carousels; each carousel has either 23 […]