TSQL Challenge 75 - Find the Episode and Sequence based on interval
The challenge is to find the Episode and Sequence based on interval.
2012-02-06
1,264 reads
Jacob Sebastian
TSQL Challenge 74 - Find the expiring quantity of material
The challenge is to create a query for a report that show expiring material
2012-01-23
916 reads
TSQL Challenge 73 - Implement Word Wrapping in TSQL
The challenge is to wrap the text by specified position.
2012-01-09
2,883 reads
TSQL Challenge 72 - Calculate the Payroll Hours of Employees
This challenge invites you to solve a payroll challenge which requires to calculate the number of hours employee worked in a week.
2011-12-26
1,812 reads
TSQL Challenge 71 - Play mangled words game in TSQL
Your task is to process the input table that contains several mangled words and try to 'un-mangle' them and validate them against a 'dictionary' table.
2011-12-12
1,390 reads
TSQL Challenge 70 - Find the longest sequence of alphabets in a string
This challenge invites you to identify the longest sequence of alphabets from a string.
2011-11-28
969 reads
TSQL Challenge 69 - Find the most relevant advertisement based on keyw
Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table.
2011-11-14
590 reads
TSQL Challenge 68 - Generate kaprekar kernel or series from numbers
This challenge invites you to Generate kaprekar kernel or series from numbers.
2011-10-31
879 reads
TSQL Challenge 67 - Find the longest sequence of alphabets in a string
This challenge invites you to identify the largest sequence of alphabets from a string.
2011-10-17
922 reads
TSQL Challenge 66 - Find the most relevant advertisement based on keyw
A website wants to display most relevant ads on each of its web pages based on the keywords associated with each page.
2011-10-03
559 reads
Blogs
Getting References for GenAI Results
By Steve Jones
I wrote an editorial on the view of GenAI tech from execs and someone...
SQL Server 2025 Is Here – AI Just Changed Everything!
By Rohit Garg
Top 10 Features of SQL Server 2025 #SQLServer2025 #MicrosoftSQL #DatabaseUpdates #SQLAI #SQLFeatures #SQLServerCopilot #VectorSearch...
SQL Blunders: Stop Writing These Pointless Queries & Write Smarter!
They run, they return data. So what? Some SQL queries just waste your time...
Forums
High Availability Reversed - Force secondary unless failure
Hi I have sql2022 in H/A with a primary and a secondary server. My...
Question of the Day
Calculating Month End
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