Unexpected symbol 'GROUP'

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
DaveBoltie
Posts: 1
Joined: Mon 30 Mar 2015 11:33

Unexpected symbol 'GROUP'

Post by DaveBoltie » Thu 25 Oct 2018 10:59

When doing a Schema Compare between a scripts folder and a database, I get an error on the following stored procedure

The error message is: Additional information: Unexpected symbol 'GROUP' D:\projects\......\Schema\Stored
Procedures\etl_deeds_bulk.A1a_spExamine_ClearancesProvinces.sql (3, 15)

This is the contents of the file in the scripts folder (and it's the same in database, i.e. table, schema names etc. are all valid)

Code: Select all

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [etl_deeds_bulk].[A1a_spExamine_ClearancesProvinces]
AS BEGIN

  SELECT        
    srcClearance, srcProvince, srcTownship, srcRegistrationDivision, srcErfNo,
    COUNT(1) AS Count
  FROM            
    etl_deeds_bulk._Standard_Property
  WHERE
     (srcID_type1 >= etl_deeds_bulk.fnType1_ID_Range_Lowest() AND srcID_type1 <= etl_deeds_bulk.fnType1_ID_Range_Highest())
  GROUP BY 
    srcClearance, srcProvince, srcTownship, srcRegistrationDivision, srcErfNo
  ORDER BY 
    srcClearance, Count DESC

END
GO
System info: SQL 2016, dbForge Studio for SQL Server 5.5.327, WIndows 10 64 bit v1709, build 16299.726

alexa
Devart Team
Posts: 2604
Joined: Fri 24 Jun 2011 14:17

Re: Unexpected symbol 'GROUP'

Post by alexa » Mon 29 Oct 2018 12:44

Could you please provide us the file you are experiencing issues with from the scripts folder? The issue may be connected with not visible characters. Herewith, please do not make any changes in the file.

Also, please provide us a screenshot of the page 'Source and Target'. We are interested in the values SQL Server Version + Default Collation that are defined for the scripts folder.

You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

Post Reply