• Hi All, I got null value for the below statement

    set @val = null but for the below statement

    select @val = (select val from #empty) i got

    Invalid object name '#empty'

    Is it i have to declare #empty first ?