TSQL Challenge 65 - Solving the Running Total Problem
This challenge invites you to solve one of the most common calculation challenges seen in applications that deal with financial -transactions.
2011-09-19
1,634 reads
This challenge invites you to solve one of the most common calculation challenges seen in applications that deal with financial -transactions.
2011-09-19
1,634 reads
This challenge invites you to solve a payroll challenge which requires special calculation of holidays and absences that are adjacent to holidays
2011-09-05
1,352 reads
2011-08-22
1,882 reads
Read the input string and break each sentence into groups of 5 words. A row may contain more than one sentence. Each sentence in the input should start a new group.
2011-08-08
1,206 reads
This challenge is to generate an HTML calendar based on the data stored in a table.
2011-07-25
1,829 reads
Your job is to read a string containing product hierarchy information and generate a relational table (result set) representing the hierarchy of categories.
2011-07-11
976 reads
Your job is to generate a string using Forsyth-Edwards Notation which represents the final position of pieces after performing a series of moves from the original position
2011-06-27
841 reads
Your job is to read the input string and generate a result set that represents the position of pieces in a chess board.
2011-06-13
1,746 reads
Your job is to scan the trades data and identify combination of trades that match a given rollup data.
2011-05-30
890 reads
This challnge invites you to generate a Sierpinsky carpet using TSQL
2011-05-16
2,509 reads
By Steve Jones
I wrote an editorial on the view of GenAI tech from execs and someone...
By Rohit Garg
Top 10 Features of SQL Server 2025 #SQLServer2025 #MicrosoftSQL #DatabaseUpdates #SQLAI #SQLFeatures #SQLServerCopilot #VectorSearch...
They run, they return data. So what? Some SQL queries just waste your time...
Hi I have sql2022 in H/A with a primary and a secondary server. My...
I want to calculate the end of the previous month as a date that I can use in running a report. What is the best way to do this in SQL Server 2022, assuming I have a date stored in @d?
See possible answers