Microsoft Enterprise Development – Page 2 – Information Technology Tips, Tricks and Techniques

T-SQL Trick: Use Recursive CTE To Get Hierarchical Data

Nov 10, 2023Jul 30, 2026 Babur Mansoor

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

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

Nov 1, 2023Jul 30, 2026 Babur Mansoor

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

Category: Microsoft Enterprise Development

T-SQL Trick: Use Recursive CTE To Get Hierarchical Data

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

Post Categories

Recent Posts