SQL-Challenges - Improve your SQL Server Skills
  • Home
  • SQL Challenges
    • Level 200
    • Level 300
    • Level 400
  • Contact us
  • FAQ
Select Page
SQL Challenge #7 – Dynamically added attributes

SQL Challenge #7 – Dynamically added attributes

by Uwe Ricken | Apr 7, 2025 | Level 300, SQL Challenges

Problem Description / Requirement This – simplified – problem arises from software that allows for individual customization to meet customer needs. A customer uses the software as a grading system for students at their university. A separate column has been...
SQL Challenge #7 – Dynamically added attributes

SQL Challenge #5 – When Constraints not work

by Uwe Ricken | Feb 17, 2025 | Level 300, SQL Challenges

Problem Description / Requirement A new customer contacts you. Their developers have created a dashboard that contains five KPI components that visualize the importance of orders according to a given status. The status of an order can only have 3 states! high normal...
SQL Challenge #7 – Dynamically added attributes

SQL Challenge #4 – Nightmares with User Defined Functions

by Uwe Ricken | Feb 9, 2025 | Level 300, SQL Challenges, Uncategorized

Problem Description / Requirement The customer has developed an application that he himself has developed and swears by the use of user-defined functions. The developers argue that user-defined functions create reusable code that makes work easier. A calculated...

SQL Challenges

  • SQL Challenge #7 – Dynamically added attributes 2025-04-07
  • SQL Challenge #6 – Locking locks your SQL Server 2025-03-03
  • SQL Challenge #5 – When Constraints not work 2025-02-17
  • SQL Challenge #4 – Nightmares with User Defined Functions 2025-02-09
  • SQL Challenge #3 – Case Sensitive Searches 2025-02-02
  • Imprint
  • Data Protection
  • RSS

db Berater GmbH | | Büchenweg 4 | 64390 Erzhausen | Phone: +49 (0) 6150 5082955 | E-Mail: info@db-berater.de |    Umsetzung