• Not much different

    select a =1 into #tabx

    union

    select a=2



    Clear Sky SQL
    My Blog[/url]