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,625 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,625 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,347 reads
2011-08-22
1,872 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,201 reads
This challenge is to generate an HTML calendar based on the data stored in a table.
2011-07-25
1,823 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
971 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
839 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,742 reads
Your job is to scan the trades data and identify combination of trades that match a given rollup data.
2011-05-30
884 reads
This challnge invites you to generate a Sierpinsky carpet using TSQL
2011-05-16
2,500 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers