TSQL Challenge 38 - Calculate SQL Stars awarded to the Winners of TSQL
This challenge involves parsing a delimited string and applying some logic to perform some calculations based on the position of tokens within the string.
2010-09-06
1,495 reads
This challenge involves parsing a delimited string and applying some logic to perform some calculations based on the position of tokens within the string.
2010-09-06
1,495 reads
This is a challenge to identify the downtime of servers from the log data generated by a monitoring application.
2010-08-23
1,532 reads
This challenge invites you to create a graph/chart using T-SQL
2010-08-09
3,816 reads
This challenge has a (fake) reference to the 24 Hours of PASS event and your task is to count the number of attendees who watched the complete presentation of each speaker.
2010-07-26
1,482 reads
This challenge is all about searching for two keywords in a string with a maximum distance of 'one word' between them.
2010-07-12
1,709 reads
This problem is related to a reservation system where customers book a service and pay it in one or more transactions which may happen on different dates.
2010-06-28
1,638 reads
The idea of this challenge is to clean up the phrase from the words identified as 'noise' words from the beginning and end of sentences.
2010-06-14
2,751 reads
This challenge is adapted from a budgeting system used in a large company to perform quarterly analysis of what kind of work will be done and where it will be done. Project Managers make plans and the estimated hours of work required from each employee each month end up in a central database. Top managers want to see a synthesis of this by department and profession
2010-05-31
2,449 reads
This is a matrix transposition challenge. Your job is to change the position of the numbres in a 5x5 matrix.
2010-05-17
2,132 reads
Your job is to reorganize the items in the table by sales amount (quantity * price). Reorganize the items from left to right, bottom to top. The item with the highest sales amount should come on top left of each invoice.
2010-05-03
1,836 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
WhatsApp:0817819444 Jl. Raya Ngunut I No.100, Lingkungan 6, Ngunut, Kec. Ngunut, Kabupaten Tulungagung, Jawa...
WhatsApp:0817819444 Jl. Raya Durenan - Bandung, Genengan, Bandung, Kec. Bandung, Kabupaten Tulungagung, Jawa Timur...
Comments posted to this topic are about the item Server-level Roles
In SQL Server 2025, can I alter a fixed server role?
See possible answers