Many of you who follow my blog know my close friend Jacob Sebastian, a SQL Server MVP and founder of the amazing site T-SQL Challenges. Regardless of your expertise level, challenges like these are designed to make you think critically and push you to the next level. While some developers excel in writing complex T-SQL code, many others are still learning but share a deep passion for T-SQL. Jacob’s T-SQL Challenge is his unique contribution to the community, helping developers think creatively, mentoring them, and guiding them to become better coders.
I frequently recommend the T-SQL Challenge site to developers eager to learn T-SQL. However, one common concern they express is uncertainty about where to start. To help, I’ve decided to write monthly blog posts discussing specific challenges and offering hints to help developers get started. I hope this initiative encourages you to take on these challenges and break the ice.
TSQL Beginners Challenge 12 – Find the Available Registration Dates
This challenge involves determining the available registration dates based on event schedules and registration data.
Hint:
- Get Date Time in Any Format – UDF – User Defined Functions
- Few Useful DateTime Functions to Find Specific Dates
TSQL Beginners Challenge 13 – Validate GUID Values and Perform a Horizontal and Vertical Count of Characters
This challenge requires validating GUID values and performing a horizontal and vertical count of the characters: 1, 2, 3, 4, 5, A, B, C, D, E.
Hint:
TSQL Challenge 35 – Find the Total Number of ‘Full Attendees’ in Each 24 HOP Session
The recent 24 Hours of PASS event (popularly known as #24HOP on social media) was an exciting SQL Server event. For this challenge, fictional attendance data was created. Your task is to count the number of attendees who watched the complete presentation of each speaker.
Hint:
Get Involved and Share Your Ideas
If you solve any of these challenges or have alternative approaches, feel free to share them in the comments or with the community. T-SQL Challenges are a great way to test your skills and grow as a developer.
Reference: Pinal Dave (https://blog.sqlauthority.com)
2 Comments. Leave new
Thanks Pinal for being a support for TSQL Challenges always!
Really like the concept of TSQL Challenges, it pushes you think outside the box, normally one tends to get used to a certain pattern of logic. These challenges make you push beyond conventional ideas. Kudos to Jacob and team for coming out with such a concept.