## Using OPENROWSET to Read Excel Worksheets from SQL Server: Part 1 – How to Set Up the System

Julia P. from the Learning Tree Transact-SQL Programming course writes “I’ve tried to use the OPENROWSET function to query Excel files, but I keep getting the same error. No matter what I try, SQL Server responds with “OLE DB provider ”Microsoft.Jet.OLEDB.4.0” for linked server ”(null)” returned message ”Could not find installable ISAM.”.” Hi, Julia. Unfortunately,lots […]

## How to Write DAX Summary Queries In Excel Using PowerPivot: The SUMMARIZE Function

In the previous segment, we saw how to write DAX statements in Excel to query Power Pivot Data. In this segment, we will take a first look at the SUMMARIZE function. While the DAX queries discussed here could be executed in the Management Studio against an Analysis Services tabular mode database, here we will be […]

## Writing DAX Summary Queries Using PowerPivot and Excel QueryTable Objects

Don’t get me wrong. Excel PivotTables are one of the best things since pizza and beer. (And considering how much I enjoy that particular combination of snack and beverage, that’s really saying something.) Nevertheless, there are times when you want to take full control, write your own DAX query, and display the results in a […]

## How to Use CROSS APPLY with Derived Tables in Transact SQL Queries

Armelle G, a student in Learning Tree’s SQL Server Transact-SQL Programming course asks “Is CROSS APPLY only used with T-SQL Functions?” Great question Armelle! Many SQL Server folks would answer “yes” but the fact is that CROSS APPLY can also be used with subqueries. CROSS APPLY allows you to create the equivalent of correlated derived tables in […]

## Linear Regression using Microsoft Excel: Part 3 – How to Interpret the Results

Linear Regression using Microsoft Excel – Part 3 Interpreting the Results of a Linear Regression At first glance, the summary report for an Excel Linear Regression might seem to be a hodgepodge of cryptic numbers. In fact, the basic Excel summary report is pretty typical. The first thing we might take a look at is […]

Type to search blog.learningtree.com

Do you mean "" ?