Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.
2022-01-19
554 reads
Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.
2022-01-19
4,302 reads
This month’s T-SQL Tuesday is hosted by Matthew McGiffen. His challenged is to come up with a puzzle. My entry involves a simple request that is more difficult to...
2019-05-14
This post is a response to this month’s T-SQL Tuesday #114 prompt by Matthew McGiffen. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...
The...
2019-05-14
This week’s T-SQL Tuesday invitation is all about puzzles. I’ve got an accidental puzzle that I’ve never quite solved, from one of my demos. I’m sure the answer will...
2019-05-14
The challenge is to compare the data of the rows and group the input data. The data needs to be grouped based on the Product ID, Date, TotalLines, LinesOutOfService.
2012-10-08
1,788 reads
The challenge is to find the Tax Code based on Price. Each sales amount is uniquely made up by the sum of one or more prices. Based on this you should assign the tax code to each price.
2012-09-17
1,342 reads
This challenge is to generate a game scheduler based on the Teams given in a table.
2012-07-04
1,473 reads
The challenge is to find the minimal set of intervals without creating gaps.
2012-04-16
1,514 reads
The challenge is to find the Islands(gaps) in sequential dates. You need to write a query to identify continuous intervals from the start date and end date.
2012-04-02
838 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Sample data: jan 10gb feb 15gb mar 16gb april 14gb(truncate data) may 18gb june...
Everybody (well almost) knows that if you want to learn the design patterns for...
How many table hints can I include in a query?
See possible answers