Home Forums SQL Server 7,2000 T-SQL populate one variable with the results from anothe RE: populate one variable with the results from anothe

  • 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]