TSQL Challenge 56 - Create a Sierpinski carpet using TSQL
This challnge invites you to generate a Sierpinsky carpet using TSQL
2011-05-16
2,500 reads
This challnge invites you to generate a Sierpinsky carpet using TSQL
2011-05-16
2,500 reads
This challenge to multiply two positive integer strings and return their product. The strings can be really long: up to 1024 digits
2011-05-02
1,291 reads
Your job is to write a query that identifies the longest matching country/area code from each phone number based on the information stored in an area-code reference table.
2011-04-18
1,185 reads
A SQL Server instance is set up to log the session start time and end time into a table. Given this table, your job is to find all time intervals in which no one is logged in.
2011-04-04
1,519 reads
This challenge is intended to calculate company's wage spent below a top level manager.
2011-03-21
1,616 reads
This challenge invites you to write a query that converts binary values into decimal format.
2011-03-07
6,696 reads
The purpose of this challenge is to test your query writing skills with a limited set of TSQL keywords.
2011-02-21
1,701 reads
Several technicians are sent to a customer premises to do a certain maintenance work. Your task is to process the activity log entered by each technician and identify overlaps.
2011-02-07
1,393 reads
This challenge is to parse and evaluate arithmetic expressions using TSQL.
2011-01-24
2,278 reads
A table contains the list of modifications made to each card. Your job is to write a query that shows the first number, current number (most recent) and the number of changes made.
2011-01-10
944 reads
By Steve Jones
This month is a great topic to me. I think growing and improving your...
By Brian Kelley
Once upon a time, I used to think of difficult technical questions to ask...
By DataOnWheels
Ever since Excel made its debut in the 1980’s, it has been used as...
Hello I need help on writing this query. This is what i need. I...
We've been testing out Azure SQL Managed Instance and created SSIS packages to run...
Greetings, I need to transform data returned in a query from several tables as...
If I want to enable a trace flag for a specific query, how do I do it?
See possible answers