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,262 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
911 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,810 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,386 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
967 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
588 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
878 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
920 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
The Book of Redgate–Being Reasonable
By Steve Jones
As a part of the Book of Redgate, we have a series of (red,...
Azure Data Factory Pipeline Debugging Fails with BadRequest
I recently had a new pipeline fail. It was actually a copy of an...
Unlocking Real-Time Financial Insights: The Power of Microsoft Fabric
By Chris Yates
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...
Forums
How to get result from deleted row
Hi Guys I have a store proc that delete a row from a and...
Count of Distinct Values
Hi If value is 21000030 it should return 4 not 5 . In first...
Joining against min date only
This is one of those things very hard (for me)to explain in words. See...
Question of the Day
Rolling Back CUs
Can I rollback a cumulative update and remove it from my SQL Server instance?
See possible answers