Tag Archives: SQL

Using SQL to read from a web service

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 … Continue reading

Posted in SQL 2012 | Tagged , | Leave a comment

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 … Continue reading

Posted in SSIS | Tagged , , , , | Leave a comment

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 … Continue reading

Posted in SharePoint 2013, SQL 2012 | Tagged , | Leave a comment

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 … Continue reading

Posted in SQL Administration, SSAS | Tagged , , , | Leave a comment

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 … Continue reading

Posted in SQL 2005, SQL 2008, SQL Administration | Tagged | Leave a comment

Importing data from Excel

Importing data from excel is very easy and you have several options to get you started…

Posted in SQL 2000, SQL 2005, SQL 2008 | Tagged , , , | Leave a comment