Using MATCH and INDEX

Hello. This article is about looking up values in Excel. Balaji asks: How can I create a Query that displays maximum value in one column and the date corresponding to the maximum value in the adjacent column ?   There are several ways to do this. In this video, I will have a look at the MATCH and INDEX formulas to solve […]

Read more

SQL Server video course – Session 1

70-461 Session 1: Querying Microsoft SQL Server 2012 About This Course This course is the foundation for the Microsoft Certificate 70-461: “Querying Microsoft SQL Server 2012″. Rather than present one huge course, this course takes some of the basics and then goes in depth. The basics presented are: how to install SQL Server, and how to create and drop tables. […]

Read more

SQL Server videos

Learn SQL Server by watching videos Having a certification in SQL Server can be advantageous to your career, but there’s a lot to concentrate on. Where do you start? What would Microsoft want you to learn? Well, Microsoft has an examination about T-SQL, the language about adding data to and retrieving information from SQL Server. It is called “70-461 Querying […]

Read more

WDW Today

Episode 1426 – Buy Or Sell Episode 1425 – December 2014 Preview Episode 1424 – Listener Questions Episode 1423 – Attraction Mashups Episode 1422 – Toddlers And Tweens Episode 1421 – Listener Questions Episode 1420 – Mickey’s Very Merry Christmas Party 2014 Preview Episode 1419 – Once Upon A Time Episode 1418 – Listener Questions Episode 1417 – Looking Forward […]

Read more
1 2 3 7