Teaching is a vocation or career? I remember to ask this question to myself many years ago, specifically when I was living in my birth country Nicaragua. Maybe in other context or social realities this never would be a question and less a dilemma, however, the context and circumstances determine us to think and ask…
Author: geohernandez
My first experience as speaker in SQLBits
First at all, I would like to start this simple blog saying: Thank you everyone who was part of this marvelous adventure, my wife who support me in an exceptional way from the beginning, especially encourage me to do a step forward, you know how much I love you Lauren , and thanks to my…
Implementing CTE for filling gaps inside a sequence
This is the second article of a series dedicated to implementing Recursive Common Table Expression in different kind of scenarios, and this time I will address another use case; it basically consists in filling gaps inside a sequence of an incomplete range of dates. I would like to comment that the next example has been…
Using recursive CTE for generating a specific number of rows
I remember the first time that I discovered the amazing feature called Common Table Expression (CTE), it was during my first read of Itzik Ben-Gan book (T-SQL Querying), maybe one of the most interesting feature together with Windows Functions. I know, I am a declared fan of CTE, but we can start defining a CTE as…