Programming Tips & Tricks
T-SQL Trick: Use Recursive CTE To Get Hierarchical Data
In a previous article we learnt how to use CTE (Common Table Expression) to render dates in a date range. In this example we’ll use somewhat advance technique to show a data in a heirarchical form. Using the regular T-SQL query this is almost impossible to achieve it without coding in a strored procedure […]
Android Phone Tips & Tricks
Control Your Windows Computer from Your Phone
There are occasions when you’re at a remote location, like during traveling, and you’re required to access your office or home computer, for instance to retrieve some important information from it. You may not have a laptop or a tablet at the moment but you’re likely to have a cell phone. Worry not! you […]