Continuing from the last SSRS tutorial on creating a SQL Server Reporting Services report with dynamic query and parameters, one caveat about the report is that it only works for one record search at a time.While this may be fine for a customer … [Continue reading]
A simple way to calculate the duration of a running program with a start and end time. The information should be presented in an hour:minutes:seconds format with leading zeroes (i.e., 00:00:00). Two local variables are used to demonstrate the query. … [Continue reading]
With the latest release of Adobe Creative Cloud Suite, I've been having issues to install any of CC programs from the suite due to the issues to even get Creative Cloud Desktop application on my Windows 8 updated. Every time the update file is run, … [Continue reading]
A quick way to populate data from one table to another using Transact-SQL. The objective is to create a copy of the table and populating it at the same time and then create an SQL script to refresh the data when necessary. This can be achieved by … [Continue reading]
After installing Linux Mint, these are the things you may want to keep it up to date and configured properly.Get Updates Open Update Manager by clicking on the shield icon on the bottom right-hand corner (see inset) and click on the Install … [Continue reading]