Dynamic SQL in dataset

• Sam1980

  SSC Enthusiast

  Points: 128

  More actions

  March 12, 2011 at 2:12 pm

  #246735

  Hi All,

  I am trying to get the following code in a dataset but it says incorrect syntax near "=". Can anybody please help?

  ="IF" & Parameters!Department.Value & "= 'Mkg'

  BEGIN

  Exec " & Parameters!Department.Value & ".dbo.sp_storedprocedure1

  END

  ELSE

  BEGIN

  Exec " & Parameters!Department.Value & ".dbo.sp_storedprocedure2

  END"

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  March 14, 2011 at 1:32 am

  #1298208

  Where exactly are you trying to do this?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP