Home Forums SQL Server 2012 SQL 2012 - General Combining variable values with result set RE: Combining variable values with result set

  • November 13, 2013 at 6:12 am

    #1666025

    Can you add a cross join to the dynamic sql? Or maybe this:

    SELECT * FROM (@SQL) qry

    CROSS JOIN (SELECT @a a, @b-2 b) x