T-SQL error handling use cursor or while loop
- or -
Post a project like this3673
$40
- Posted:
- Proposals: 4
- Remote
- #436989
- Completed
Description
Experience Level: Intermediate
General information for the business: Not a business
Database management system (DBMS): Microsoft SQL Server
Description of requirements/functionality: Hi,
I have a requirement for write a stored procedure in T-SQL that will take data from staging table and insert into permanent table. The stored procedure should be able to handle all the errors occurs from each row and capture them in a variable.
1. The total number of fields are 13. When the data is loaded into staging table it is being loaded as varchar (all fields).
2. The permanent table has the correct data types and check constraints.
3. Stored procedure (using cursor or while loop) should be able to handle all the validation, errors, wrong datatypes from each records (append all the errors for each row) and capture them in a variable and write that record with it's error into an excel file
Extra notes:
Database management system (DBMS): Microsoft SQL Server
Description of requirements/functionality: Hi,
I have a requirement for write a stored procedure in T-SQL that will take data from staging table and insert into permanent table. The stored procedure should be able to handle all the errors occurs from each row and capture them in a variable.
1. The total number of fields are 13. When the data is loaded into staging table it is being loaded as varchar (all fields).
2. The permanent table has the correct data types and check constraints.
3. Stored procedure (using cursor or while loop) should be able to handle all the validation, errors, wrong datatypes from each records (append all the errors for each row) and capture them in a variable and write that record with it's error into an excel file
Extra notes:
Lucky M.
98% (38)Projects Completed
42
Freelancers worked with
38
Projects awarded
39%
Last project
25 Jul 2021
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies