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?

  • error

    Msg 2705, Level 16, State 3, Line 1

    Column names in each table must be unique. Column name 'STATUS' in table 'NewTable' is specified more than once.

    1.

    [TBL_IRIS_IMAGES_MASTER]

    [GUID] [varchar](50) NOT NULL,

    [LEFT_IMAGE] [image] NULL,

    [RIGHT_IMAGE] [image] NULL,

    [IMAGE_FORMAT] [varchar](20) NULL,

    [DEVICE_ID] [varchar](20) NULL,

    [ENROLLTIME] [datetime] NULL,

    [OPERATORID] [int] NULL

    2.

    [TBL_CONTRACT_EMP_MASTER]

    [ID] [numeric](18, 0) NOT NULL,

    [GUID] [varchar](50) NULL,

    [EP_NO] [varchar](20) NULL,

    [NAME] [varchar](200) NULL,

    [CONTRACTOR_CODE] [varchar](50) NULL,

    [CONTRACTOR_NAME] [varchar](200) NULL,

    [SUBCONTRACTOR_NAME] [varchar](200) NULL,

    [PLANT_CD] [varchar](50) NULL,

    [SKILLCODE] [varchar](50) NULL,

    [WORK_AREA] [varchar](50) NULL,

    [DISCIPLINE] [varchar](50) NULL,

    [PASSTYPE] [varchar](50) NULL,

    [PRES_ADD] [varchar](200) NULL,

    [PRES_VILLAGE] [varchar](100) NULL,

    [PRES_TALUKA] [varchar](100) NULL,

    [PRES_DISTRICT] [varchar](100) NULL,

    [PRES_TEHSIL] [varchar](100) NULL,

    [PRES_CITY] [varchar](75) NULL,

    [PRES_STATE] [varchar](50) NULL,

    [PRES_PIN] [varchar](15) NULL,

    [PRES_TEL_NO] [varchar](50) NULL,

    [FATHER_HUS_NAME] [varchar](100) NULL,

    [DT_BIRTH] [datetime] NULL,

    [DT_JOIN] [datetime] NULL,

    [EP_VALID_TILL] [datetime] NULL,

    [LICENSE_NO] [varchar](50) NULL,

    [GENDER] [varchar](10) NULL,

    [BLOOD_GROUP] [varchar](10) NULL,

    [RELIGION_CD] [varchar](50) NULL,

    [ID_MARK] [varchar](150) NULL,

    [HEIGHT] [smallint] NULL,

    [DT_LEAVE] [datetime] NULL,

    [STATUS] [char](1) NULL,

    [COMMENT] [varchar](200) NULL,

    [ENROLLTIME] [datetime] NULL,

    [OPERATORID] [int] NULL,

    [MODIFY_DT] [datetime] NULL,

    [CONTRACTOR_TYPE] [varchar](80) NULL,

    [WORKAREA_CATEGORY] [varchar](50) NULL,