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,283 reads
This challenge is to parse and evaluate arithmetic expressions using TSQL.
2011-01-24
2,283 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
947 reads
This challenge is a slightly enhanced version of the ‘remove leading zeros’ problem
2010-12-27
1,714 reads
This challenge involves evaluating mathematical expressions presented using Roman Numerals and return the result of each expression.
2010-12-13
1,673 reads
The first part of your job is to identify the unique color combinations of products and the second part is to identify the products that have the given color combination.
2010-11-29
1,351 reads
This challenge involves writing a logic to identify incomplete segments and missing elements in an electronic data integration file exchanged between two applications.
2010-11-16
850 reads
This challenge involves writing a logic to change the column position of values in the output based on the presence and absence of other values on each output row.
2010-11-01
2,827 reads
This challenge involves extracting email addresses from a table that contains text data downloaded from various websites.
2010-10-18
2,250 reads
This challenge involves converting numeric values from binary format to hexadecimal format.
2010-10-04
1,641 reads
This challenge is related to an inventory management application where your job is to calculate the profitability by item (cost v/s sales) using First-In-First-Out (FIFO) processing method.
2010-09-20
2,122 reads
I was sick of changing context in Azure Data Studio while cleaning up things...
By Zikato
The crime spree in Digitown is not ending. This time 20 cars have been...
By Steve Jones
One of our mission statements in the Book of Redgate says: attempt to do...
Comments posted to this topic are about the item Shining a Light on Shadow...
Hi, I would love to hear if anyone can tell me why a CAST...
hi, one of our sister division's erp extract view is going thru at least...
In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?
See possible answers