Category: Programming Tips and Tricks

  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 […]

  Using a traditional programming language like C# or Python you can use “for” and “while” loop constructs to generate a sequence of numbers, dates, string values or anything else super-easily. But here we’ll learn how to generate date values in a specific range using Transact-SQL query. We’ll not use any SQL stored procedure. Let’s […]

  There are occasions when it is required to reveal running totals before rendering the grand total in a report. Usually calculating and providing running total is the job of a report designer software module. But if you’re using SQL Server database then Transact-SQL (a.k.a T-SQL) provides this facility right in the query. Let’s assume […]

  MS Excel provides a myriad of built-in data validation rules based on custom formula that enables users to control and validate the data entered into cells, ensuring its accuracy, integrity and consistency. With Data Validation, users can define rules and constraints on cell values, helping to prevent errors and inconsistencies in their spreadsheets. This […]

Working with Sql to query a database is both simple and complex but is an alluring experience for everybody. For the simple requirement it is quite simple and straight forward, but for complex scenarios you have to give a fair amount of thought before finalizing your desired query. Below we’ll walk you through some simple […]

While developing in IBM/HCL Notes you may stumble across the situations where your search of documents requires more than one key. The custom function placed below provides you with the same facility. Its prototype is pretty simple, it gets the form name, first field name and its key value, and second field name and its […]

XML is everywhere, and you can’t (and most probably don’t want to) get rid of it. Pulling in data from heterogeneous technologies in a single well defined and widely accepted data format, that is XML, has made a developer’s life far comfortable than ever. PowerShell makes handling XML quite simple. It converts XML elements to […]

Windows PowerShell is a robust programming platform which has the capability to cover, by and large, everything a developer can imagine. In this article we’ll articulate a little example to get the weather update through RSS feed. This example uses the PowerShell’s Invoke-RestMethod cmdlet to get weather information from BBC Weather update. Invoke-RestMethod cmdlet pulls […]