Recently, I needed to find correct addresses for physical locations that I had only latitude and longitude. The general process to do this follows: script to PROVE OUT the process for generating good addresses from JEA bad addresses thru the…
Tag: SQL
Direct query to excel (AceOleDb.dll)
So, often you need to get excel data into SQL ‘in a hurry’ for analysis. After you’ve done a base case analysis you can go about getting the data in a more ‘regular’ fashion. What’s the fastest way to get an…
Government Transparency Powered by SharePoint 2013 and Sql 2012
Hey, everyone! There’s a great event here in Jacksonville, Florida. It’s coming in May. Saturday, 9 May, to be specific. It is like a mini Tech-ed. Free Food. Great Technical presentations. Click the picture to the right to register! Lots…
Reading an SSAS cube thru SQL using MDX
Do you need the ability to read a cube, but you want to read it thru SQL? And, why would you do this? Well, for example, suppose you wanted to email the results of a certain MDX query…and you didn’t…
Character selection by location in a string
Suppose you had a 4 character field (prefx), and you wanted to find all those records where the 2nd and 4th characters were numeric, with the other two being alphabetic. Here’s a neat, simple solution: select * from TableName where prefx…
Importing data from Excel
Importing data from excel is very easy and you have several options to get you started…