Insert into arrest.dbo.arrest_OBTS select 
       [ARRESTTYPE]
      ,[WARSTATUS]
      ,[OTTIC]
      ,[OFFENSENO]
      ,[WARRANTNO]
      ,[ARRESTNO]
      ,[JAILBOOKNO]
      ,[OBTS]
      ,[OTHER]
      ,[REPORTDATE]
      ,[REPORTTIME]
      ,[COURTCASE]
      ,[LNAME]
      ,[FNAME]
      ,[MNAME]
      ,[TITLE]
      ,[DOB]
      ,[APPROX_AGE]
      ,[RACE]
      ,[SEX]
      ,[HISPANIC]
      ,[HEIGHT]
      ,[WEIGHT]
      ,[HAIR]
      ,[EYES]
      ,[SSN]
      ,[OCA]
      ,[OCCUR_DATE]
      ,[OCCUR_TIME]
      ,[OCCUR_DAT2]
      ,[OCCUR_TIM2]
      ,[OC_HOUSENU]
      ,[OC_QUAD]
      ,[OC_STREET]
      ,[OC_HOUSESU]
      ,[OC_CITY]
      ,[OC_STATE]
      ,[OC_ZIP]
      ,[OC_ZONE]
      ,[OC_DISTGRD]
      ,[DGEO_LAW_SUB2]
      ,[DGEO_LAW_SUB3]
      ,[WDIST]
      ,[DISTGRID]
      ,[SENTCOURT]
      ,[RCVDCOURT]
      ,[SENTDATE]
      ,[RCVDDATE]
      ,[SENTJUDGE]
      ,[RCVDJUDGE]
      ,[HOLD]
      ,[HOLDTILL]
      ,[RECALLED]
      ,[RECALLTEXT]
      ,[RECALLAFT]
      ,[MAILED]
      ,[ARRAIGN]
      ,[COURTARR]
      ,[JUDBOND]
      ,[JUDANY]
      ,[JUDPRO]
      ,[JUDPTRIQ]
      ,[JUDNONE]
      ,[JUDCASH]
      ,[JUDPTR]
      ,[JUDRORSIGN]
      ,[JUDPURGE]
      ,[JUDPURGEC]
      ,[LEOBOND]
      ,[LEO_NONE]
      ,[LEO_ROR]
      ,[RETCOURT]
      ,[RETDATE]
      ,[RETTIME]
      ,[ARR_DATE]
      ,[ARR_TIME]
      ,[RESIST]
      ,[RESISTTYPE]
      ,[WEAPON]
      ,[RETTEXT]
      ,[WEAPONID]
      ,[WEAPONTYPE]
      ,[DRINKING]
      ,[DRUGS]
      ,[ALCOHOLTYPE]
      ,[DRUGTYPE]
      ,[RESIDENCY]
      ,[ARRESTJURISDICTION]
      ,[ARRESTEDPRIOR]
      ,[INJURY]
      ,[INJURYEXTENT]
      ,[AHOUSENU]
      ,[AQUAD]
      ,[ASTREET]
      ,[AHOUSESU]
      ,[ACITY]
      ,[ASTATE]
      ,[AZIP]
      ,[AZONE]
      ,[ADISTGRID]
      ,[ADGEO_LAW_SUB2]
      ,[ADGEO_LAW_SUB3]
      ,[CRIMESCENE]
      ,[PHYEVID]
      ,[PHYEVIDDES]
      ,[ARROFFNO]
      ,[ARROFFNAME]
      ,[ARROFFPERNO]
      ,[ARROFFUNIT]
      ,[REPOFFNO]
      ,[REPOFFNAME]
      ,[REPOFFPERNO]
      ,[REPOFFUNIT]
      ,[REPOFFAGENCY]
      ,[FORWARDTO]
      ,[FINISHED]
      ,[ARRSUPAPP]
      ,[ARRSUPNO]
      ,[ARRSUPNAME]
      ,[ARRSUPPERNO]
      ,[ARRSUPDATE]
      ,[ARRSUPTIME]
      ,[REPTAKER]
      ,[REPTAKERPERNO]
      ,[REPTAKERD]
      ,[REPTAKERT]
      ,[REPTAKERDE]
      ,[REPTAKERTE]
      ,[SERVEBY]
      ,[SERVEDBYPERNO]
      ,[SERVEBYD]
      ,[SERVEBYT]
      ,[UNSERVEBY]
      ,[UNSERVEDBYPERNO]
      ,[UNSERVEBYD]
      ,[UNSERVEBYT]
      ,[ALERTDATE]
      ,[ALERTTEXT]
      ,[MODBY]
      ,[MODBYPERNO]
      ,[MODDATE]
      ,[MODTIME]
      ,[LOCK]
      ,[LOCKPSW]
      ,[LOCKBY]
      ,[LOCKDATE]
      ,[LOCKTIME]
      ,[UNLOCKBY]
      ,[UNLOCKDATE]
      ,[UNLOCKTIME]
      ,[END]
      ,[SROARREST]
      ,[IBRSArrestType]
      ,[UNIQUEKEY]
      ,[BOOKDATE]
      ,[BOOKTIME]
      ,[JAILDATE]
      ,[JAILTIME]
      ,[FP_BY]
      ,[COUNTY_IDNO]
      ,[FDLE_NO]
      ,[DOC_NO]
      ,[FBI_NO]
      ,[MAND_COURT]
      ,[NOT_COURT]
      ,[COURT_LOC]
      ,[MIRANDA_WARN]
      ,[HOLD_AGCY]
      ,[VERIFIED_BY]
      ,[REASON]
      ,[BONDDATE]
      ,[REL_DATE]
      ,[REL_TIME]
      ,[REL_AM_PM]
      ,[BOND_CHG1]
      ,[BOND_CHG2]
      ,[BOND_TYPE1]
      ,[BOND_TYPE2]
      ,[JUV]
      ,[FELONY]
      ,[TFELONY]
      ,[MISD]
      ,[TMISD]
      ,[ORDINANCE]
      ,[OTHERCHG]
      ,[FP_IDONLY]
      ,[FP_CRIM]
      ,[FP_AFIS]
      ,[FP_BY_PERNO]
      ,[OATHADMINPERNO]
      ,[VERBYPERNO]
      ,[RET_AM_PM]
      ,[REL_OFFPERNO]
      ,[OC_BUS_NAME]
      ,[ARR_BUS_NAME]
      ,[OCCUR_AM_PM]
      ,[SENTTIME]
      ,[SENT_AM_PM]
      ,[AssignType]
      ,[AssignUnit]
      ,[AssignPerNo]
      ,[OATHADMIN]
      ,[REL_OFF]
      ,[ARRESTTYPE_FHP]
      ,[OFFENSEJURISDICTION]
      ,[TRANSMITTED]
      ,[RADIONO]
      ,[ORI]
      ,[XMITTED_ON]
      ,[JUDOPTION8]
      ,[JUDOPTION9]
      ,[JUDOPTION10]
      ,[LEO_OPTION3]
      ,[LEO_OPTION4]
      ,[LEO_OPTION5]
      ,[LEO_OPTION6]
      ,[LEO_OPTION7]
      ,[LEO_OPTION8]
      ,[LEO_OPTION9]
      ,[LEO_OPTION10]
      ,[OC_LATITUDE]
      ,[OC_LONGITUDE]
      ,[ALATITUDE]
      ,[ALONGITUDE]
      ,[ETHNICITY]
      ,[EnteredInCIC]
      ,[SpecialConditionExist]
      ,[SpecialConditionDesc]
      ,[AssignAgency]
      ,[LJBONDFLAG]
      ,[SubmitStatus]
      ,[SubmitExternalDocID]
      ,[OccurFromDateTime]
      ,[OccurToDateTime]
      ,[ReportDateTime]
      ,[ArrestReportPersonFKey]
      ,[ReportStatus]
      ,[OfficerCreatedDateTime]
      ,[ReportCompletedDateTime]
      ,[OfficerCompleted]
      ,[OfficerCompletedDateTime]
      ,[ECSOID]
  FROM [ARREST].[dbo].[Arrest_OBTS]
GO