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