sql - Week based count -


i have requirement retrieve data in below fashion

weeks  delay_count 0           6          1           0 2           3 3           4 4           0 5           1            6           0 7           0     8           0        9           0 10          2 11          0         12          0       13          0     14          0 15          3

here weeks hard coded column 0 15 , delay_count derived column. have column delay_weeks. based on values in column need populate values in delay_count column (derived column)

delay_weeks column values below.

blank blank  blank  2 10 5 blank  3 2 10 2 3 3 3 0 0 15 22 29

conditions:

  • when delay_weeks blank or 0 count in delay_count column should 1
  • when delay_weeks 3 in delay_count column count should 1 under week 3
  • when delay_weeks 10 in delay_count column count should 1 under week 10
  • when delay_weeks greater or equal 15 in delay_count column count should 1 under week 15.

i wrote code below

select   "weeks", a."delay_count"     (select     level "weeks"                 dual           connect level <= 15) m,          (select   value, count (value) "delay_numbers"               (select case                                           when attr11.value >= 15                                              '15'                                           else attr11.value                                        end                                      value                       docs,                            (select object_id, value, attribute_type_id                               attributes                              attribute_type_id =                                       (select attribute_type_id                                          attribute_types                                         name_display_code =                                                  'attribute_type.delay in weeks')) attr11                      docs.obj_id = attr11.object_id(+)            group value)    m."weeks" = a.value(+) 

select   weeks,   nvl(cnt, 0) delay_count   (select level-1 weeks dual connect level < 17)   left join (     select        nvl(least(attr11.value, 15), 0) weeks,       count(0) cnt            docs        left join (         attributes attr11          join attribute_types atr_tp using(attribute_type_id)       )          on atr_tp.name_display_code = 'attribute_type.delay in weeks'         , docs.obj_id = attr11.object_id     group nvl(least(attr11.value, 15), 0)   ) using(weeks) order 1

Comments

Post a Comment

Popular posts from this blog

monitor web browser programmatically in Android? -

i've got tricky question here. need users make payment bank (namely barclaycard) in uk. so, have https url , add parameters (such amount pay, order reference, etc) url, start http connection intent.actionview, redirect user browser can enter credit card details on bank's webpage , make payment our account successfully. far ? the code use below (i changed values privacy reasons) problem is, need app when user has completed/failed/cancelled payment. barclaycardautomatically redirects particular url when payment has succeeded, 1 if failed. there no way of knowing when barclaycard payment has succeeded go android app somehow ? button cardbutton = (button) findviewbyid(r.id.card_button); cardbutton.setonclicklistener(new view.onclicklistener() { @override public void onclick(view arg0) { string prehashstring = new string(); string prohashstring = new string(); string shapassphrase = new string(); shapassphrase = "gsvth£h70zkh...
Read more

Shrink a YouTube video to responsive width -

i have youtube video embedded on our website , when shrink screen tablet or phone sizes stops shrinking @ around 560px in width. standard youtube videos or there can add code make go smaller? you can make youtube videos responsive css. wrap iframe in div class of "videowrapper" , apply following styles: .videowrapper { float: none; clear: both; width: 100%; position: relative; padding-bottom: 56.25%; padding-top: 25px; height: 0; } .videowrapper iframe { position: absolute; top: 0; left: 0; width: 100%; height: 100%; } the .videowrapper div should inside responsive element. padding on .videowrapper necessary keep video collapsing. may have tweak numbers depending upon layout.
Read more

wpf - PdfWriter.GetInstance throws System.NullReferenceException -

i'm trying create pdf document using itextsharp 5.3.4 using following document document = new document(); filestream stm = new filestream(filename, filemode.create); pdfwriter writer = pdfwriter.getinstance(document, stm); i'm getting system.nullreferenceexception following stack trace: system.nullreferenceexception occurred hresult=-2147467261 message=la référence d'objet n'est pas définie à une instance d'un objet. source=itextsharp stacktrace: à itextsharp.text.version.getinstance() innerexception: i've verified neither document nor stm null, , if select "continue" in vs12 document created - exception thrown. updated itextsharp 5.4.0 , it's still occurring. can't find information on anywhere - got ideas? make sure not catching exceptions. nullreferenceexception can 1 caught , handled inside itextsharp, don't care it. fact can continue supports theory. change following setting verify: debug -> exceptions ...
Read more