Re: Dynamic SQL in SPL

In article <6ub6rv$f2t$1@news.xmission.com>, NGuffey@jdriscoll.com (Nicole Guffey) wrote: > > Does anyone know of a way to use Dynamic SQL or Macro Expansion within > Stored Procedure Language? I need to be able to pass all or part (say > only > the where clause) of a SQL Statement as a parameter of type varchar to a > stored proc and have it parsed and executed as a SQL Statement. > > Thank you, > Nicole Guffey > DBA > J. Driscoll & Associates > nguffey@jdriscoll.com > > You can't do this, but you can dynamically create SPL and then execute it from inside existing SPL Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 # www.wfsoftware.co.uk