Visual studio build error 2015 using microsoft azure sql

Apr 17 2017 8:40 AM

Hi ,
once i am tired to build my project .I am getting build error in the below code.
CREATE PROCEDURE [dlm].[uspScriptTableInsertionForADW]

(
----- - - ----- some code-------

CREATE TABLE #selectColListTable

WITH

(



DISTRIBUTION = ROUND_ROBIN

)
Error:
SQL80001:Incorrect syntax near 'WITH' .Excepting '(' ,or AS.

Answers (1)