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?

  • shouldn't it be this?

    If you're still getting problems run it with the table getting created with one column, then run it so it gets created with two columns, then three etc etc

    IF EXISTS(SELECT 1 FROM sys.objects where name='NewTable' and type='U')

    begin

    DROP TABLE NewTable

    end

    GO

    select tr.[GUID]as gid,[EP_NO],[NAME],

    [CONTRACTOR_CODE],[CONTRACTOR_NAME],

    [SUBCONTRACTOR_NAME],[PLANT_CD],[SKILLCODE],[WORK_AREA],

    [DISCIPLINE],[PASSTYPE],[PRES_ADD],[PRES_VILLAGE],

    [PRES_TALUKA],[PRES_DISTRICT],[PRES_TEHSIL],[PRES_CITY],

    [PRES_STATE],[PRES_PIN],[PRES_TEL_NO],[FATHER_HUS_NAME],

    [DT_BIRTH],[DT_JOIN],[EP_VALID_TILL],[LICENSE_NO],

    [GENDER],[BLOOD_GROUP],[RELIGION_CD],[ID_MARK],[HEIGHT],

    [DT_LEAVE],[COMMENT],[STATUS],tr.[ENROLLTIME] as EntTime,

    tr.[OPERATORID] as OptID, [MODIFY_DT],[CONTRACTOR_TYPE],[WORKAREA_CATEGORY]

    into NewTable from tbl_contract_emp_master TR inner join

    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')