Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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: 836 | 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.


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones