SQL Server Comparing Subsequent Rows for Duplicates -

-

I am trying to write a SQL server query, but there was no luck and wondering how anyone Any idea may be get my query.

What I'm trying to do:

I have several column tables whose names I am working with TaskID, StatusCode, Timestamp. Now in this table, the work for one of our systems has been completed, which runs throughout the day and when some runs are done, then the timestamp and the status of the work is done based on the situation.

Sometimes whatever happens, the work table can be updated with a new timestamp, but the status code will not change after the last update of the work so that two or more consecutive tasks The status code for rows can be the same. When I say that consecutive rows are meant in relation to the timestamp.

For example, there may be twenty rows on position 2 in position 88, after which the status code turns into something else.

Now I'm trying with no luck in that destiny, he is to receive a list of all functions and Stetsods and timestamp, but in a situation where I have more than one row Rows To work with the same stats, I want to take the first line with the least timestamp and want to ignore the rest of the row to change the status I received.

In this case it's easy to make the value I'm a taskid which I'm filtering on so I'm just looking at the same job.

Anyone have any ideas as to how I can coudl this or maybe something that I probably read to help?

Thank you Irfan.

There are a few ways to do this: 

  SELECT T1.task_id, T1.status_code, T1.status_timestamp from My_Table T1 Connect on left My_Table T2 ON T2.task_id = T1.task_id and T2.status_timestamp & lt; T1.status_timestamp LEFT OUTER My_Table T3 ON T3.task_id = T1.task_id and T3.status_timestamp & lt; T1.status_timestamp and T3.status_timestamp & gt; T2.status_timestamp where T3.task_id zero and (T2.status_code tap or T2.status_code & lt; & gt; T1.status_code) Order

or

(My_table maximum (status_timestamp) from T3 select where T3. task_id = T1.task_id and T3.status_timestamp & LT; T1.status_timestamp) where (T2.status_code tap or T2.status_code & lt; & gt; T1.status_code) order

Fill in both ways there is going to be an exact match status_timestamp values Interpretation do (two lines may not be the exact same status_timestamp for task_id given.)


Comments

Post a Comment

Popular posts from this blog

c# - How to capture HTTP packet with SharpPcap -

-
I would like to capture all incoming HTTP packets on my machine. To do this, I am using SharpPcap which is a WinPcap The cover is. SharpPcap works very well, but it captures TCP packets and what it wants to do for me is a very low level. Does anyone know how can I easily get full HTTP requests / reactions from all these TCP packets? Thanks SharpPcap is already able to capture the packet in the same way That's what the virus does (just in the code instead of the GUI). And you can either either parse them directly or you can put them in the drive in the common .pcap file format. The steps to parse the capture are: Open a connection at any time Loop a while Or start capturing using an event callback Parsing the raw packet for the type you want If you are reading .PPP dump files In addition to calling you an offline capture reader is almost the same, there is no need to select an interface, and you can set the majority There is no need to do the modes. All st...
Read more

php - Multiple Select with Explode: only returns the word "Array" -

-
By using Wordpress I have created a multiple selection box so that users can select categories to exclude. When the page is initially loaded, I see my predefined default option. However, when I select a new value and I save ... I only see the word "Array" and have not chosen anything else? & lt; Class = "amultiple" id = "& lt; php echo $ value ['id'] ;? gt;" name = "& gt; php echo $ value ['id'] ;; gt; []" Multiple = "multiple" size = "8" & gt; & Lt ;? Php global option; Foreign currency ($ value as value $) {if (get_settings ($ value ['id']) === FALSE {$$ value ['id'] = $ value ['std']; } And {$$ value ['id'] = get_settings ($ value ['id']); }} $ Ranges = & amp; Amp; Categories ('type = post & orderbiz = name & amp; hide_empty = 1'); If ($ ranges) {$ ex_cat = implode (',', $ tt_cat_exclude); Forex Currency ($ range a...
Read more

php - jQuery AJAX Post not working -

-
I do not understand why this script does not work. It has something to do within AJAX PostScript / Function. Right now, when I submit my form, it runs php code on the same page. What it should do, send the values ​​of the form for Project_Azax.fp, then there will be a refund of success on the page which is correct or false. $ (document) .ready (function () {$ ('div # didIt'). Hide (); $ ('form [name = adminForm]'). Submit (function () ($ {'.post' ('/ project_ajax.php', {action: $ ('[name = action]') Val (), pId: $ ('[name = pId]'). Val (), name ('[Name = name]'. Val (), url: $ ('[url = url]'). Val (), summary: ('[summary = summary]'). Val ()}, Function (data) {if (data.success) {$ ('div # didIt') .Sliddown ('slow');} and {warning ('unsuccessful SA!');}}, 'Jason'); return false ;});}); What is the code for project_ajax.php below ... if ($ _ POST ['action'] == ...
Read more