Series: SQL CSV XML Project

In this series we process an incoming csv file and prepare an xml file for output.

SQL Server csv in xml out Project

Using SQL Server we will design a project where we process an incoming csv file and prepare an […]

April 1, 2017 in SQL Server tagged project / xml / csv / algorithm / SQL CSV XML Project by Mike

SQL Server csv in xml out Project Part 2
This is a continuation of the first post. Input Data Specifications – Initial Thoughts In this section we […]

April 1, 2017 in SQL Server tagged relationships / primary key / foreign key / database diagram / xml / csv / SQL CSV XML Project by Mike

SQL Server csv in xml out Project Part 3

This post continues from the previous post, Part 2. Here is the sql code that creates a new […]

April 1, 2017 in SQL Server tagged out / export / sql / xml / csv / SQL CSV XML Project by Mike

SQL Server csv in xml out Project Part 4

Importing From CSV We now need to look at importing our csv file into the tables. The stored […]

April 2, 2017 in SQL Server tagged export / sql / xml / csv / out / SQL CSV XML Project by Mike

SQL Server csv in xml out Project Part 5

In this blog we will be focusing on an easier part of the program. All we need to […]

April 2, 2017 in SQL Server tagged csv / out / export / sql / xml / SQL CSV XML Project by Mike

SQL Server csv in xml out Project Part 6

In this post we will focus on cleaning the incoming data. In our project, the stored procedure that […]

April 4, 2017 in SQL Server tagged validation / out / export / sql / xml / csv / clean / SQL CSV XML Project by Mike

SQL Server csv in xml out Project Part 7

This is the code for usp_11CheckIfFileExists in our I Love Books project. Before looking at all of the […]

April 7, 2017 in SQL Server tagged export / sql / xml / csv / out / SQL CSV XML Project by Mike

SQL Server csv in xml out Project Part 8

Part 8 usp_15NoDuplicateOrders

April 7, 2017 in SQL Server tagged sql / xml / csv / out / export / SQL CSV XML Project by Mike

SQL Server csv in xml out Project Part 9

Part 9

April 7, 2017 in SQL Server tagged out / export / sql / xml / csv / SQL CSV XML Project by Mike

SQL Server csv in xml out Project Part 10

Part 10

April 7, 2017 in SQL Server tagged export / sql / xml / csv / out / SQL CSV XML Project by Mike

SQL Server csv in xml out Project Part 11

Create XML From Tables What we have in the input file is shown below. After that, we show […]

April 7, 2017 in SQL Server tagged xml / csv / out / export / sql / SQL CSV XML Project by Mike

SQL Server csv in xml out Project Part 12

Create an Empty xml File Here we need to simply create an empty xml file. The file will […]