Rohit Dhand

In case your Outlook 2016 hangs at the Starting Screen and does not move ahead, we can do the following: Go to the following path: C:\Users\ \AppData\Local\Microsoft\Outlook And rename the current file of the Outlook. Now restart the Outlook again and it will re-create the outlook file for you and its starts working.

If you upgrade your HDD to SSD (Samsung EVO 850) in your Dell Inspiron Model, you won't be able to install a fresh copy of Windows 10 booted from CD Drive or USB, though the BIOS Setup shows and recognizes SSD. It will give you a BSOD Error (Memory_Management) from the USB bootable which is created from Windows 7 USB Creator Tool. In order to resolve this, we need to create our USB Bootable of Windows 10 with the help of a Software named - Rufus. https://rufus.akeo.ie/ When we create a bootable USB with the above software we need to select MBR scheme for UEFI. That's the actual problem. So now if we try to boot again, the Windows 10 will be able to install without any error.

We cannot have two statements in the same procedure that creates a temp table with the same name.  So instead of using SELECT INTO, we can use CREATE TABLE  and INSERT command Combination. By this way we create Temp tables in same procedure with the same name.