It gets better look at the create for the table

USE [SLADB]

GO

/****** Object: Table [dbo].[ProdDataTB] Script Date: 09/01/2012 12:27:41 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ProdDataTB](

[MachineName] [nvarchar](10) NULL,

[ModeName] [nvarchar](10) NULL,

[FileName] [nvarchar](10) NULL,

[JobName] [nvarchar](10) NULL,

[UserName] [nvarchar](10) NULL,

[TransactionKey] [int] NULL,

[StartDate_Time] [nvarchar](25) NULL,

[StartDate] [datetime] NULL,

[StartTime] [time](7) NULL,

[StartYYYY] [float] NULL,

[StartMM] [float] NULL,

[StartDD] [float] NULL,

[StartHH] [float] NULL,

[StartNN] [float] NULL,

[StartSS] [float] NULL,

[Spare1] [nvarchar](6) NULL,

[EndDate_Time] [nvarchar](30) NULL,

[EndDate] [datetime] NULL,

[EndTime] [time](7) NULL,

[EndYYYY] [float] NULL,

[EndMM] [float] NULL,

[EndDD] [float] NULL,

[EndHH] [float] NULL,

[EndNN] [float] NULL,

[EndSS] [float] NULL,

[Spare2] [nvarchar](6) NULL,

[RunTime] [int] NULL,

[DelayTime] [int] NULL,

[MachineStopTime] [int] NULL,

[OperatorStopTime] [int] NULL,

[MachineFaultTime] [int] NULL,

[OperatorFaultTime] [int] NULL,

[OldPiecesFed] [int] NULL,

[OldPiecesCompleted] [int] NULL,

[NumMachineStops] [int] NULL,

[NumOperatorStops] [int] NULL,

[NumDelays] [int] NULL,

[Feeder_00_Count] [int] NULL,

[Feeder_01_Count] [int] NULL,

[Feeder_02_Count] [int] NULL,

[Feeder_03_Count] [int] NULL,

[Feeder_04_Count] [int] NULL,

[Feeder_05_Count] [int] NULL,

[Feeder_06_Count] [int] NULL,

[Feeder_07_Count] [int] NULL,

[Feeder_08_Count] [int] NULL,

[Feeder_09_Count] [int] NULL,

[Feeder_10_Count] [int] NULL,

[Feeder_11_Count] [int] NULL,

[Feeder_12_Count] [int] NULL,

[Feeder_13_Count] [int] NULL,

[Feeder_14_Count] [int] NULL,

[Feeder_15_Count] [int] NULL,

[Feeder_16_Count] [int] NULL,

[Feeder_17_Count] [int] NULL,

[Input_Feeder_Count] [int] NULL,

[Input_SubFdr_1_Count] [int] NULL,

[Input_SubFdr_2_Count] [int] NULL,

[Input_SubFdr_3_Count] [int] NULL,

[Input_SubFdr_4_Count] [int] NULL,

[Input_SubFdr_5_Count] [int] NULL,

[Avg_Chassis_Speed] [float] NULL,

[Shift] [int] NULL,

[Total_Pcs_Outsorted] [int] NULL,

[Total_Pcs_Outsorted_Good] [int] NULL,

[Total_Pcs_Outsorted_Maybe] [int] NULL,

[Total_Pcs_Outsorted_Bad] [int] NULL,

[Total_Pcs_Outsorted_Unk] [int] NULL,

[Bin_01] [int] NULL,

[Bin_02] [int] NULL,

[Bin_03] [int] NULL,

[Bin_04] [int] NULL,

[Bin_05] [int] NULL,

[Bin_06] [int] NULL,

[Bin_07] [int] NULL,

[Bin_08] [int] NULL,

[IST_Bin1] [int] NULL,

[IST_Bin2] [int] NULL,

[IST_Bin3] [int] NULL,

[IST_Bin4] [int] NULL,

[IST_RunOut] [int] NULL,

[Mtr1_NoPrint] [int] NULL,

[Mtr2_NoPrint] [int] NULL,

[Mtr3_NoPrint] [int] NULL,

[Mtr4_NoPrint] [int] NULL,

[Edge_Mark1] [int] NULL,

[Edge_Mark2] [int] NULL,

[Edge_Mark3] [int] NULL,

[No_Seal] [int] NULL,

[Empty_Cycles] [int] NULL,

[Filled_Cycles] [int] NULL,

[MidRunTime] [nvarchar](8) NULL,

[SubShiftExt] [nvarchar](2) NULL,

[ShiftDateAdjust] [nvarchar](10) NULL,

[PiecesFed] [int] NULL,

[PiecesCompleted] [int] NULL,

[Spare3] [nvarchar](68) NULL,

[ID] [int] IDENTITY(1,1) NOT NULL,

CONSTRAINT [PK_ProdDataTB] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

Notice the StartYYYY, StartMM, StartDD, StartHH, StartNN, StartSS. these are what is used I assume to make up the strange string StaerDate_Time.

Can I take these values join them together and insert into a datetime column ?

I can then drop these columns from my c# app and have a slick table

Thanks

Jay