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
This challenge is to parse and evaluate arithmetic expressions using TSQL.
2011-01-24
2,277 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
This challenge is a slightly enhanced version of the ‘remove leading zeros’ problem
2010-12-27
1,709 reads
This challenge involves evaluating mathematical expressions presented using Roman Numerals and return the result of each expression.
2010-12-13
1,667 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,350 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
849 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,825 reads
This challenge involves extracting email addresses from a table that contains text data downloaded from various websites.
2010-10-18
2,246 reads
This challenge involves converting numeric values from binary format to hexadecimal format.
2010-10-04
1,634 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,092 reads
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Read Only Replica in SQL...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I've had some backups of my encrypted databases failing with the error "BACKUP 'DBName'...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers