If you use Telerik's RadGrid but don't want to use the default styling template, there's a quick way to apply your own CSS style to it. This may not be as sophisticated as using the skinning feature, but it surely does the trick.The first thing … [Continue reading]
How to Create SSRS Report with Dynamic Query and Multi-Value Parameters
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]
How to Calculate Duration Between Two Dates in T-SQL
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]
Creative Cloud Desktop Failed to Install on Windows
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]
How to Copy Data from One Table to Another
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]