TSQL Challenge 56 - Create a Sierpinski carpet using TSQL
This challnge invites you to generate a Sierpinsky carpet using TSQL
2011-05-16
2,507 reads
This challnge invites you to generate a Sierpinsky carpet using TSQL
2011-05-16
2,507 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,294 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,191 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,526 reads
This challenge is intended to calculate company's wage spent below a top level manager.
2011-03-21
1,619 reads
This challenge invites you to write a query that converts binary values into decimal format.
2011-03-07
6,697 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,395 reads
This challenge is to parse and evaluate arithmetic expressions using TSQL.
2011-01-24
2,282 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
946 reads
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
We value your privacy. This policy explains what personal data we collect and why. What...
Why would using variables in place of hard coded numbers impact a query's performance? ...
Hello SSC! I have been tasked with optimizing a stored procedure the imports data...
Hey everyone, I'm trying to access an XML file download from a government website...
What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?
See possible answers