Database

MongoDB shell version: 3.2.12
connecting to: test
> db.mycoll.find()
> db.mycoll.insertOne( { x: 1} )
{
        "acknowledged" : true,
        "insertedId" : ObjectId("5c62fb2a93ce6e6b14a14369")
}
> db.mycoll.insertOne( { able: 1, baker: "hello world", charlie: {xray: 0, zulu: 6.9} } )
{
        "acknowledged" : true,
        "insertedId" : ObjectId("5c62fb5293ce6e6b14a1436a")
}
> db.mycoll.find()
{ "_id" : ObjectId("5c62fb2a93ce6e6b14a14369"), "x" : 1 }
{ "_id" : ObjectId("5c62fb5293ce6e6b14a1436a"), "able" : 1, "baker" : "hello world", "charlie" : { "xray" : 0, "zulu" : 6.9 } } 

CREATE TEMP TABLE TMP(id INTEGER PRIMARY KEY AUTOINCREMENT, DataOra text);
INSERT INTO TMP(DataOra) SELECT DataOra from EVENT  order by DataOra;
DELETE FROM EVENT where DataOra <= (SELECT DataOra from TMP where id = 5000);

DECLARE @PERIOD TABLE (start_time DATETIME, end_time DATETIME)

INSERT INTO @PERIOD(start_time)
SELECT t.start_time FROM (
  SELECT act_start_time_utc AS start_time, state_cd AS new_state, LAG(state_cd, 1) OVER (ORDER BY act_start_time_utc ASC) AS last_state
  FROM SRPMES901007.WWMESDB.dbo.job
  WHERE act_start_time_utc IS NOT NULL) AS t
WHERE t.new_state = 4 AND t.last_state <> 4

UPDATE period
SET end_time = (SELECT TOP(1) act_start_time_utc FROM SRPMES901007.WWMESDB.dbo.job WHERE state_cd <> 4 AND act_start_time_utc > period.start_time ORDER BY act_start_time_utc ASC)
FROM @PERIOD period 

SELECT * FROM @PERIOD ORDER BY start_time ASC

UPDATE @temp
SET formula_name = r.name, formula_version = r.version
FROM dbo.fn_GetFormulaForJob(wo_id, oper_id,seq_no) r

UPDATE T
SET formula_name = r.name, forumula_version = r.verion
FROM @TEMP As T
CROSS APPLY dbo.fn_GetFormulaForJob(T.wo_id, T.oper_id, T.seq_no) As r;

Member 14136263 wrote:

i used your app sqlite compare

Member 14136263 wrote:

Any idea ?