sql server - Derive grouped meaning from multiple rows -

-

what ways, in last query, include batch 2 in result "processing"? each batch has several child tasks. overall status of batch i'm looking for.

task status meanings:

  • 1=pending
  • 2=processing
  • 3=retrying
  • 4=complete
  • 5=failed

batch status:

  • batch 1 processing
  • batch 2 in middle of processing, pending task has not yet been picked up. seconds before happens, i'm not interested in "sleeping" type state.
  • batch 3 processing retrying task
  • batch 4 not processing because nothing has been picked up.
  • batch 5 not processing because complete
  • batch 6 not processing because has failed task.

code:

if object_id('tempdb..#t') not null drop table #t create table #t (batchid int, taskstatus int) insert #t(batchid, taskstatus) values        (1, 1),        (1, 2),        (1, 4),        (2, 1),        (2, 1),        (2, 4),        (2, 4),        (3, 3),        (3, 4),        (4, 1),        (4, 1),        (5, 4),        (5, 4),        (6, 5),        (6, 4)  select      batchid,      1 processing #t taskstatus in (2,3) group batchid

update

select batchid, 1 processing   table1  group batchid having sum(case when taskstatus in(2,3) 1 else 0 end) > 0      or (sum(case when taskstatus in(1,4) 1 else 0 end) = count(*)     , count(distinct taskstatus) = 2)

here sqlfiddle demo.

original answer original version of question:

select batchid, 1 processing   table1  group batchid having count(*) * 4 > sum(taskstatus)

this query returns batches incomplete tasks.

here sqlfiddle demo.


Comments

Post a Comment

Popular posts from this blog

c# - SelectList with Dictionary, add values to the Dictionary after it's assigned to SelectList -

-
i have following code - dictionary<string, string> mydict = new dictionary<string, string>(); mydict.add("keya", "valuea"); mydict.add("keyb", "valueb"); ienumerable<selectlistitem> myselectlist = new selectlist(mydict, "key", "value") further down in program, want add values mydict . possible? if yes, how? want - myselectlist.mydict.add("keyc", "valuec"); if you're wanting add items mydict, possible, , changes reflected in of myselectlist 's enumerations long changes made before enumeration (e.g. using .tolist() ) generated. as worked example: dictionary<string, string> mydict = new dictionary<string, string>(); mydict.add("keya", "valuea"); mydict.add("keyb", "valueb"); ienumerable<selectlistitem> myselectlist = new selectlist(mydict, "key", "value...
Read more

how can i manage url using .htaccess in php? -

-
i want manage url of website right showing me www.computermall.co.in/product_details.php?prdid=34 but want www.computermall.co.in/product_details/34 how can it? i have tried this options +followsymlinks -multiviews rewriteengine on rewritebase /computermall # uri-path directly the_request variable rewritecond %{the_request} ^(get|head)\s/(.*)\.php [nc] # strip extension , redirect permanently rewriterule .* /%2 [r=301,l,nc] rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewritecond %{request_uri} !\.php [nc] # map internally original resource rewriterule ^(.*)$ $1.php [l,qsa] try this: rewriteengine on rewriterule ^product_details/prdid/([^/]*)$ /product_details?prdid=$1 [l] edit: removed leading slash
Read more

ios - I get the error Property '...' not found on object of type '...' -

-
appdelegate.h #import <uikit/uikit.h> @interface appdelegate : uiresponder <uiapplicationdelegate> @property (strong, nonatomic) uiwindow *window; @end appdelegate.m #import "appdelegate.h" #import "firstviewcontroller.h" #import "secondviewcontroller.h" @implementation appdelegate - (bool)application:(uiapplication *)application didfinishlaunchingwithoptions: goes on normal app.......... @end firstviewcontroller.h #import <uikit/uikit.h> @interface firstviewcontroller : uiviewcontroller @property (strong, nonatomic) iboutlet uiimageview *bground; - (ibaction)settingspressed:(id)sender; - (ibaction)startpressed:(id)sender; @end @class secondviewcontroller; @interface secondviewcontroller : uiviewcontroller @property(strong,nonatomic)secondviewcontroller *secondviewcontroller; @end firstviewcontroller.m #import "firstviewcontroller.h" @interface firstviewcontroller () @end @implement...
Read more