SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

TSQL Challenge 43 – Identifying incomplete segments and missing elemen

By Jacob Sebastian,

This challenge involves writing a logic to identify incomplete segments and missing elements in an electronic data integration file exchanged between two applications.

The problem presented in this challenge is related to a validation requirement needed as part of an electronic data exchange process. There are two applications involved in this process. The “Sender” sends a ASCII file in a predefined format to the “Receiver”. The “Receiver” application accepts the files and inserts the data into a staging table. The following illustration shows how the data looks like. 

Click the link below to get the sample data and enter the challenge.

TSQL Challenge 43 - Identifying incomplete segments and missing elements

Total article views: 837 | Views in the last 30 days: 1
Related Articles

TSQL Challenge 65 - Solving the Running Total Problem

This challenge invites you to solve one of the most common calculation challenges seen in applicatio...


TSQL Challenge 37 - Calculate the downtime and duration of servers bas

This is a challenge to identify the downtime of servers from the log data generated by a monitoring ...


TSQL Challenge 39 - Calculate Gross Profit by Item using FIFO method

This challenge is related to an inventory management application where your job is to calculate the ...


TSQL Challenge 64 - A Payroll calculation Challenge

This challenge invites you to solve a payroll challenge which requires special calculation of holida...


TSQL Challenge 77-Transform monthly resource efforts to weekly actuals

The challenge is to transform monthly resource efforts into weekly actuals.