GPIS – iHistorian Implementation – SQL 2005

Declare @ProcessDate DateTime, @DataCollectionID integer-- Takes the current DateTime and converts it to a numeric representation. select @ProcessDate = getdate()-- Insert a DataCollection record. INSERT INTO DataCollections(DateTime, InspectionGUID, OperatorID, SupervisorID, ShiftId, TeamId, LineGUID, Obs, ProductGUID) SELECT @ProcessDate, ................
................