T-sql Scripts
OBEJCTIVE:
WRITE tsql STORED PROCEDURES for 1 database to be run as jobs.
The database contains 2 Schemas and 96 tables but no stored produres yet. The stored procedures will only use 20% of all the tables.
TASKS TO PERFORM:
—————–
1. Requirement (1 hour).
Read through the requirement doc as a baseline to create the stored procedures
2.Create the ETL scripts as Stored procedures to transfer data from between the two schemas.(1 day)
3. Stored procedure 1 represents a hierarchic structure in the destination table, I have already scripted this script and you can just plug it into the stored procedure. (1 hour)
4. Create Error handling for all the stored procedure based of the requirement doc ( 4 hours)
5. Write a documentation about all stored procedures
DELIVERABLES:
————–
1. Stored procedures to transfer the data
2. Word documentation about all the stored procedures
PROCESS:
——–
1. I deliver the DDL to create the existing tables and schema
I include only some sample data since it’s too huge
2. You start the work and ask any required information about the role
of each stored procedure if not clear.
3. You deliver the work, I test it on an existing database that I have set up and check everything is working, and pay you immediately.
