TSQL Challenge 76 - Identify the sequence of accounting transactions
The challenge is to identify the sequence of accounting transactions.
2012-02-20
1,625 reads
Jacob Sebastian
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,268 reads
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
920 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,815 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,394 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
975 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
597 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
880 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
932 reads
Blogs
PASS Data Community Summit 2025 Slides and Code
By alevyinroc
Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with...
Tech Conferences and Expanding Your View
By Brian Kelley
Tech conferences aren't just for networking and learning how to address a problem you're...
Managing subscribers, creating newsletters
By DataOnWheels
When I created the website on WordPress, I was expecting all the features I...
Forums
Getting the Schema for Tables
Comments posted to this topic are about the item Getting the Schema for Tables
An Unexciting Exciting Release
Comments posted to this topic are about the item An Unexciting Exciting Release
UNLOGGED Tables in PostgreSQL: When Speed Matters More Than Durability
Comments posted to this topic are about the item UNLOGGED Tables in PostgreSQL: When...
Question of the Day
Getting the Schema for Tables
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; GOSee possible answers