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
510 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,229 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,774 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,337 reads
This challenge is to generate a game scheduler based on the Teams given in a table.
2012-07-04
1,471 reads
The challenge is to find the minimal set of intervals without creating gaps.
2012-04-16
1,511 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
837 reads
By Steve Jones
I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...
It’s me again with my apparently semi-annual blog post. This time we’re going to...
By Steve Jones
I saw an article on this and realized I had no idea how to...
Hey Folks, So I have SQL Transactional Replication set up on a database that's...
Hello, how can I change this code to txt pipe format? $DataSet.Tables[0] | Export-csv...
HI I have a data set with student info; Name, Type there would be...
Ask SSC