populate one variable with the results from anothe

• Stacey

  SSCommitted

  Points: 1766

  More actions

  June 13, 2003 at 7:52 am

  #82375

  Is it possible to populate one variable with the results from another?

  Example: SET @DBBACKUP = (EXEC @CMD_MDATE).

  I have already populated @CMD_mdate, and would like to use its results in another variable.

  Thank you

  Stacey W. A. Gregerson

  
  Stacey W. A. Gregerson
  

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  June 13, 2003 at 9:36 am

  #461328

  Hi Stacey,

  quote:

  ---

  Example: SET @DBBACKUP = (EXEC @CMD_MDATE).

  ---

  you mean something like

  declare @a datetime

  declare @b-2 datetime

  set @a = getdate()

  set @b-2 = @a

  print @b-2

  or is @CMD_MDATE some T-SQL (SELECT, blah,blah...) command?

  Cheers,

  Frank

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

• Prakash Heda

  SSCertifiable

  Points: 5539

  More actions

  June 13, 2003 at 11:13 am

  #461359

  IS THIS IS WHAT U R LOOKING FOR....

  DECLARE

  @SQLINDEXTABLENAME VARCHAR (200),

  @SQL_STMT NVARCHAR(4000)

  SET @SQL_STMT ='SELECT @SQLINDEXTABLENAME = NAME FROM SYSOBJECTS WHERE ID = 5;

  '

  EXEC SP_EXECUTESQL @SQL_STMT, N'@SQLINDEXTABLENAME VARCHAR(200) OUTPUT', @SQLINDEXTABLENAME OUTPUT

  PRINT @SQLINDEXTABLENAME

  Cheers..Prakash

  Prakash

  Prakash Heda
  Lead DBA Team - www.sqlfeatures.com
  Video sessions on Performance Tuning and SQL 2012 HA