syntax error in SPROC during comparison
johnatarchwellhealth
Posts: 7 New member
New sproc found, saved to project and pushed to source control successfully.
Upon Next comparison, refresh errors -Syntax Error in C:\ODS-PROD\schema-model Invalid Syntax found on line 29 in payor_import.sp_pointclickcare_daily_census.sql Line Text: CREATE PROCEDURE [payor_import].[sp_pointclickcare_daily_census]
No syntax errors to found that we can see. What next?
Upon Next comparison, refresh errors -Syntax Error in C:\ODS-PROD\schema-model Invalid Syntax found on line 29 in payor_import.sp_pointclickcare_daily_census.sql Line Text: CREATE PROCEDURE [payor_import].[sp_pointclickcare_daily_census]
No syntax errors to found that we can see. What next?
Tagged:
Answers
Issue was due to a pipe character not parsing in SSMS
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?