MSSQL Partner Table Creation
Budget: €30 – €250 EUR
I need an experienced MSSQL developer to create a comprehensive 'Partner' table for me. The table needs to store various types of data.
The project should have CRUD operation, and I'm interest only in storedProcedure who have 2 parameters.
1. @json - which will have all the data need
2. @userID - which is standard
The storedProcedure should check the integrity of data, and if it is not ok to return explicit error
This project should cover following:
- log of changes, last 10 changes per partner or top 1 year
- partner as client, (All type of clients), but not doubled
- partner as supplier, all kind of suppliers
- partners from multiple bussiness (for example for a bussness is client, for other bussness is supplier), so it should have hystorical based on that bussiness
The project should be working for Romanian Market
The ideal freelancer for this project should have extensive experience in database design and management, particularly with MSSQL. Understanding of business transaction logs and partner management systems will be a plus. Please provide examples of similar projects you've completed in your proposal. Thank you.
The project should have CRUD operation, and I'm interest only in storedProcedure who have 2 parameters.
1. @json - which will have all the data need
2. @userID - which is standard
The storedProcedure should check the integrity of data, and if it is not ok to return explicit error
This project should cover following:
- log of changes, last 10 changes per partner or top 1 year
- partner as client, (All type of clients), but not doubled
- partner as supplier, all kind of suppliers
- partners from multiple bussiness (for example for a bussness is client, for other bussness is supplier), so it should have hystorical based on that bussiness
The project should be working for Romanian Market
The ideal freelancer for this project should have extensive experience in database design and management, particularly with MSSQL. Understanding of business transaction logs and partner management systems will be a plus. Please provide examples of similar projects you've completed in your proposal. Thank you.