## 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 […]

## Linear Regression in Microsoft Excel: Part 2 – How to Perform the Analysis

Linear Regression using Microsoft Excel – Part 2. Don’t be fooled by the “Part 2”. Since we took a moment to review loading an Excel add-in, Part 2 is actually the beginning! How to do Linear Regression Analysis in Excel The first concern is locating the data that you want to analyze. It’s generally easy […]

## Linear Regression in Microsoft Excel: Part I – How to Load the Excel Analysis Toolpak

Part I: Linear Regression in Microsoft Excel: How to Load the Excel Analysis Toolpak Add-In Most readers will be familiar with loading an Excel add-in. For those who don’t, or might be rusty, here’s a quick precis of what you need to do to perform easily linear regressions in Excel. The rest of you can […]

## Is MONEY Bad? How to Use the MONEY Datatype in SQL Server

Jamal K, from Developing High-Performance SQL Server® Databases inquires… “A colleague at work said the MONEY datatype in SQL Server is bad and shouldn’t be used. Are there good reasons behind this or is it just hearsay?” Excellent question, Jamal. Before dealing with the question itself let’s consider some historical background. There’s nothing that can […]

Type to search blog.learningtree.com

Do you mean "" ?