Multiple statements are not allowed in SSMS

• hennie7863

  SSCommitted

  Points: 1653

  More actions

  October 17, 2010 at 1:21 pm

  #143765

  Hi i'm trying some MDX scripts in SSMS and i'm keep getting this error:

  Multiple statements are not allowed.

  for example:

  Scope

  (

  [Date].[Fiscal Year].&[2002],

  [Date].[Fiscal].[Month].Members

  ) ;

  This = [Date].[Fiscal].CurrentMember.Parent / 3 ;

  End Scope ;

  Anyone ideas?

  Gr,

  Hennie

• naveendas

  Mr or Mrs. 500

  Points: 590

  More actions

  October 21, 2010 at 3:08 pm

  #1240617

  You cannot use SCOPE statement in SSMS