Fix Studio

Generated SQL fixes

4 references classified, 2 reviewable drafts.

HUMAN APPROVAL

All findingsGeneratedManual review

loyalty.usp_reconcile_loyalty_customerSQL_STORED_PROCEDURE · CONVERT

FIX GENERATED

CURRENT REFERENCE

SELECT customer_id FROM loyalty.member_snapshot WHERE TRY_CONVERT(INT, customer_id) = @customer_id;

PROPOSED CHANGE

SELECT customer_id FROM loyalty.member_snapshot WHERE TRY_CONVERT(BIGINT, customer_id) = @customer_id;

operations.usp_match_regional_returnsSQL_STORED_PROCEDURE · JOIN

MANUAL REVIEW

CURRENT REFERENCE

SELECT r.return_id FROM operations.returns r JOIN commerce.orders o ON r.customer_id = o.customer_id;

PROPOSED CHANGE

Verify both join operands are BIGINT before changing the source.

finance.vw_customer_revenue_bridgeVIEW · CAST

FIX GENERATED

CURRENT REFERENCE

SELECT CAST(customer_id AS INT) AS customer_id, net_revenue FROM finance.revenue_daily;

PROPOSED CHANGE

SELECT TRY_CAST(customer_id AS BIGINT) AS customer_id, net_revenue FROM finance.revenue_daily;

exports.usp_export_customer_segmentsSQL_STORED_PROCEDURE · DYNAMIC_SQL

MANUAL REVIEW

CURRENT REFERENCE

DECLARE @sql nvarchar(max) = N'SELECT customer_id FROM ' + @table; EXEC sys.sp_executesql @sql;

PROPOSED CHANGE

Contains dynamic SQL, so the referenced object and runtime type need manual review.