We often find that after converging data from a number of sources we have duplicate records in our worksheets. In this article I show you how to strip out those duplicate rows using the Excel “Remove Duplicates” option.
In the following example we have duplicate company names in the data on our worksheet.
I’m sure all of you who work with SQL Server systems will have experienced the frustration of trying to retrieve a set of records only to find that someone is updating/deleting/inserting one or more records that are matched by your query, and locks prevent you from accessing part or all of your record set.
There are various ways in which you can select cells in Microsoft Excel, using the mouse, keyboard or a combination of the two. There are also short cuts you can use, if you are selecting cells which contain data.
This article is aimed at users who have a basic knowledge of Excel VBA.
We have launched selected courses running at our new London Location.
Our most popular courses will now be offered at both our Wokingham Training Centre and our new London location in Ealing, just 30 minutes away from Covent Garden and the many attractions that London has to offer.
For more information please give us a call or email us at info@ptr.co.uk. More information and course dates will appear on our website soon.
In July I published Part 1 of this series of blogs which explores the many ways of tackling a multi-table query.
Welcome to Part 2 of Working with Tables in Microsoft Word. (If you missed Part 1, click here)
In Working with Tables in Microsoft Word - Part 2 we will look at:
Management Studio in SQL Server 2016 has introduced a great new feature: Compare Showplan.
We offer more than just a schedule of courses. You tell us what you want and we do our best to put it together for you.
We have been busy over the last few months!
We offer you:
Relational databases store data in tables and we can retrieve information with SQL SELECT statements accessing one or more tables.
