SQL Procedure: Validate Config Data
Budget: ₹1,250 – ₹2,500 INR
I’m preparing our application for a major configuration overhaul and I need a rock-solid stored procedure that focuses exclusively on data validation. The procedure will run against our configuration tables before each deployment and must confirm that every record is correct before it reaches production.
Scope of validation
• Format & structure – verify each field follows the expected data type, length, and pattern rules.
• Range & constraints – reject any values that fall outside permitted boundaries or violate business rules.
• Dependencies between fields – catch cross-field issues (e.g., a flag set to “enabled” must have its companion value populated).
What I’ll supply
• Current table schema and sample configuration data.
• A list of the business rules that define valid ranges, required relationships, and acceptable patterns.
• Test cases we already use in-house.
Deliverables
1. Clean, well-commented SQL stored procedure script ready to drop into the database.
2. A brief read-me explaining parameters, expected result sets, and how to integrate it into our deployment pipeline.
3. Proof that the procedure correctly flags or rejects all invalid samples and allows valid records to pass (your own test script or unit test output is fine).
Acceptance criteria
The procedure must return a clear, single-row result set summarising success/failure and listing any offending record IDs with helpful messages. Performance should stay under two seconds when validating roughly 10,000 rows.
No schema changes are required—just the procedure and supporting scripts. I’m available to answer questions quickly and will test as soon as the first draft arrives so we can iterate fast.
Scope of validation
• Format & structure – verify each field follows the expected data type, length, and pattern rules.
• Range & constraints – reject any values that fall outside permitted boundaries or violate business rules.
• Dependencies between fields – catch cross-field issues (e.g., a flag set to “enabled” must have its companion value populated).
What I’ll supply
• Current table schema and sample configuration data.
• A list of the business rules that define valid ranges, required relationships, and acceptable patterns.
• Test cases we already use in-house.
Deliverables
1. Clean, well-commented SQL stored procedure script ready to drop into the database.
2. A brief read-me explaining parameters, expected result sets, and how to integrate it into our deployment pipeline.
3. Proof that the procedure correctly flags or rejects all invalid samples and allows valid records to pass (your own test script or unit test output is fine).
Acceptance criteria
The procedure must return a clear, single-row result set summarising success/failure and listing any offending record IDs with helpful messages. Performance should stay under two seconds when validating roughly 10,000 rows.
No schema changes are required—just the procedure and supporting scripts. I’m available to answer questions quickly and will test as soon as the first draft arrives so we can iterate fast.