getting values into local variables from dynamic query

• Rehan Ahmad Rattu

  SSC Eights!

  Points: 825

  More actions

  February 17, 2005 at 12:46 am

  #163353

  Hi,

  If anybody plz help me out of this myth. The problem is like

  ---

  BEGIN

  Declare @LocalVariable int

  Declare @QueryStr nvarchar(4000)

  Set @QueryStr = 'Select 1'

  -- I want this 1 to be stored into @LocalVariable after executing it in either

  -- sp_executesql or simple execute () function

  END

  ---

  Wishing Health n Wealth to all

  

  Rehan

  - Rattu

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  February 17, 2005 at 2:00 am

  #542731

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=162243

  

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]