Skip to content

James Software Development Corner

Helping Others with Software Development and Windows Operating Issues

  • Home
  • About

Month: June 2019

Windows 10 Update Error (0x800705b4)

This problem I probably caused by shutting down my computer in the middle of the new Windows Version 1903 update. An hour after restarting my computer to complete the install, my computer seemed to be hung and never loaded up … Read the rest

Author JamesPosted on June 24, 2019June 24, 2019Categories Windows 10

File Explorer: Show/Hide libraries in the left pane

Right mouse click in the white space below the Tree View on the left pane of File Explorer and uncheck ‘Show libraries’.

Do want to also hide ‘Network’ your ‘name’ shortcut, Network, Control Panel, and Recycle Bin? Uncheck ‘Show all … Read the rest

Author JamesPosted on June 24, 2019June 24, 2019Categories File Explorer

SQL Server Management Studio – Using Row_Number, Partition, and filtering on Row_number

Let’s say you want to retrieve only the first row of each question type from the question type table. The 3rd SQL statement will give you your results, but let’s explain each of 3 SQL statements.

select RowNumber, question_type 
 from
   
… Read the rest
Author JamesPosted on June 14, 2019June 14, 2019Categories SQL Server Management Studio

SQL Server Management Studio – Retrieve one child row regardless of number of grand children from another child table with or without filtering

Let’s say you want to report on each child row, but you only want to see one row based on a grand child row with filtering on the grand child row. The following SQL will not work, but instead gets … Read the rest

Author JamesPosted on June 14, 2019June 14, 2019Categories SQL Server Management Studio

SQL Server Management Studio – Retrieve one parent row regardless of number of children when filtering on children

Let’s say you want to report on each parent row, but must join a child row to do filtering on the child row, but you only want to return one row per parent. The following SQL will not work, but … Read the rest

Author JamesPosted on June 14, 2019June 14, 2019Categories SQL Server Management Studio

Recent Posts

  • iPhone – Wi-Fi Calling stops working
  • Windows 10 – Enable Hibernate in Elevated Command Prompt
  • Windows 10 – USB Safe to remove Notification missing
  • Windows 10 – Can’t login to Xbox Live with Windows 10 Live Account via the Xbox or Xbox Accessories windows application
  • Windows 10 Update Error (0x800705b4)

Archives

  • September 2021
  • February 2020
  • September 2019
  • June 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • March 2018
  • February 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • June 2017
  • May 2017
  • April 2017
  • February 2017
  • December 2016
  • October 2016
  • August 2016
  • July 2016
  • April 2016
  • March 2016
  • February 2016
  • December 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • January 2015
  • December 2014
  • October 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • January 2014
  • December 2013
  • November 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • November 2012
  • October 2012
  • September 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012

Categories

  • Active Reports 6
  • Adobe Application Manager
  • Art Work
  • Facebook
  • File Explorer
  • FileSeek
  • Firefox
  • Flash CS5.5 and AS3
  • Flash Plugin
  • Google Calendar
  • Google Chrome
  • Host Domain
  • Internet Explorer
  • iPhone
  • Malwarebytes
  • Microsoft Excel
  • Microsoft Outlook
  • Microsoft Silverlight
  • Microsoft Visual Studio
  • Microsoft Word
  • MVC 5
  • Nero
  • Network
  • NVIDIA
  • Office 2010
  • Plugins
  • Quicktime
  • Quicktime Pro 7
  • Remote Assistance
  • Remote Desktop
  • SnagIt
  • SQL Server
  • SQL Server Management Studio
  • SQL Server Reporting Services (SSRS)
  • Toon Boom Animation
  • Uncategorized
  • Vote
  • Windows 10
  • Windows 7
  • Windows 8
  • Wireless
  • Wordpress
  • Xbox
  • Zune
  • Home
  • About
James Software Development Corner Proudly powered by WordPress
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.AcceptSettingsRead More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT