TSQL Challenge 56 - Create a Sierpinski carpet using TSQL
This challnge invites you to generate a Sierpinsky carpet using TSQL
2011-05-16
2,499 reads
Jacob Sebastian
TSQL Challenge 55 - Multiply two very long decimal strings and return
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
TSQL Challenge 54 - Find the longest matching area code
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
TSQL Challenge 53 - Finding empty and non-empty intervals
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
TSQL Challenge 52: Recursive Wage Calculation in a Parent-Child dimens
This challenge is intended to calculate company's wage spent below a top level manager.
2011-03-21
1,616 reads
TSQL Challenge 51 - Convert long Binary strings to Decimal strings
This challenge invites you to write a query that converts binary values into decimal format.
2011-03-07
6,692 reads
TSQL Challenge 50 - Extracting a specifical range from random data wit
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
TSQL Challenge 49 - Identify overlapping time sheet entries of field t
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
TSQL Challenge 48 - Parse and evaluate Arithmetic Expressions using TS
This challenge is to parse and evaluate arithmetic expressions using TSQL.
2011-01-24
2,277 reads
TSQL Challenge 47 - Read the modification history and identify the fir
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
Blogs
Quick Filtering in SSMS–#SQLNewBlogger
By Steve Jones
I saw someone limit the databases they see in SSMS, which isn’t something I...
Penetration Testing your SQL Server, Part 1 – The Recon Mission
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
SQL Saturday Denver 2023–VCS Primer for the Database slides
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
Forums
Running a Service
Comments posted to this topic are about the item Running a Service
Creating Two Keys
Comments posted to this topic are about the item Creating Two Keys
Stairway to DAX and Power BI Level 26: Time Intelligence – Dates Functions: The DAX “Total to Date” Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
Ask SSC