Home Forums SQL Server 2008 T-SQL (SS2K8) create table by using select command return data? RE: create table by using select command return data?

  • October 24, 2012 at 3:24 am

    #1552179

    select status, *

    into NewTable from tbl_contract_emp_master TR inner join

    TBL_IRIS_IMAGES_MASTER tm on tr.guid=tm.guid

    and EP_NO in ('104536884','104541256','104564417','t12035676','104567770','104556221','104567536')

    select * from NewTable

    Malleswarareddy
    I.T.Analyst
    MCITP(70-451)