Recent Posts

Easy Cloud Manager – Best Cloud To Cloud Transfer Tool

  How Does Google Takeout Transfer Work? What Are Ways to Transfer Data from Google to Another Cloud?  Many people use multiple Google accounts to split their data into personal and work files. The practice of splitting one’s files into multiple accounts is not new. It helps you obtain more storage for free without upgrading. […]

Continue Reading
commonly used abbreviations

Commonly Used Abbreviations

WiFi – Wireless FidelityWWW – World Wide WebHTTP – Hyper Text Transfer ProtocolGIF – Graphics Interchange FormatJPEG – Joint Photographic Experts GroupHTML – Hyper Text Markup LanguageURL – Uniform Resource Locator ISP – Internet Service ProviderGPS – Global Positioning SystemSQL – Structured Query LanguageSMS – Short Message ServicePDF – Portable Document FormatCCTV – Closed Circuit […]

Continue Reading

HCL Notes Trick: Retrieve Details Rows From Embedded View

  HCL Notes doesn’t provide a direct way of working with a master-details scenario, may be because it’s not a relational database system where Primary-Foreign-Key relationship entails the designer platform to provide some efficient mechanism to entertain this particular scenario. So we need to devise some alternate methodology to achieve it. So in order to […]

Continue Reading

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

Continue Reading

T-SQL Trick: Use CTE to Render Dates In The Specified Date Range

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

Continue Reading