Using OPENROWSET to Read Excel Worksheets from SQL Server: Part 1 – How to Set Up the System
Feb 27,
2015
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 Use CROSS APPLY with Derived Tables in Transact SQL Queries
Jan 18,
2015
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 […]
Is MONEY Bad? How to Use the MONEY Datatype in SQL Server
Dec 22,
2014
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 […]
Which Standard Deviation & Variance to use in Excel (and SQL!).
Dec 15,
2014
A look at STDEV, STDEVP, VAR and VARP- Amy M., from Developing SQL Queries for SQL Server, writes… “I know there are two functions for standard deviation and for variance in Transact-SQL, but I can never remember when to use which.” You are so right, Amy. It is hard to know when to use STDEV […]
Announcing New IT Training Courses: Make Better Use of Your Company’s Data
Aug 8,
2014
Curious about how you can enhance your AngularJS or SQL server skills? Or do you want to learn how to capitalize on data stored in Hadoop? Develop your IT skills and make more informed business decisions with the addition of our three new IT training courses! Our 3-4 day courses are designed to deliver both […]