Skip to content
SQLInsight

SQLInsight

We Do SQL Right!

  • What’s New
  • Power BI Gallery
  • PowerPoint Downloads
  • About Us
  • Contact Us
  • Home
  • SQL

Tag: SQL

Using SQL to read from a web service

May 2, 2016 Steve Schneider

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…

Read more

SQL 2012SQL, SQL 2012Leave a Comment on Using SQL to read from a web service

Direct query to excel (AceOleDb.dll)

January 30, 2016 Steve Schneider

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…

Read more

SSISAceOleDB.dll, Excel, Import, SQL, SSISLeave a Comment on Direct query to excel (AceOleDb.dll)

Government Transparency Powered by SharePoint 2013 and Sql 2012

April 27, 2015 Steve Schneider

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…

Read more

SharePoint 2013, SQL 2012SharePoint, SQLLeave a Comment on Government Transparency Powered by SharePoint 2013 and Sql 2012

Reading an SSAS cube thru SQL using MDX

July 23, 2013 Steve Schneider

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…

Read more

SQL Administration, SSASMDX, SQL, SSAS, SSRSLeave a Comment on Reading an SSAS cube thru SQL using MDX

Character selection by location in a string

August 31, 2011 Steve Schneider

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…

Read more

SQL 2005, SQL 2008, SQL AdministrationSQLLeave a Comment on Character selection by location in a string

Importing data from Excel

July 25, 2011 Steve Schneider

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

SQL 2000, SQL 2005, SQL 2008Data Import, Excel, Import, SQLLeave a Comment on Importing data from Excel
Copyright SQL Insight 2017 © All rights reserved.
Business Era by mProThemes