mblockchain/fabric-peer/ You could set some configuration settings that would would force automatic view changes on certain time boundaries, this would bring an out of synchronization peer back in line on a more consistent basis, but that is not something you can do on the Starter Network on Bluemix you seem to be using (from your screenshot).
How this would all run, or would be configured, for a real solution environment would depend heavily on the your application and your intended use cases. Peer synchronization can be done at the cost of increased communication between peers, but the idea is not to keep all peers in synchronization as much as it is to insure that what is written to the blockchain has been agreed to through a consensus process.
Hope this helps! 

 Q:

SQL Server Pivot Table with Counts and Sums

I am trying to get an SQL Server Pivot table to work that allows me to count and then sum a number of columns (6 in total). The purpose of the pivot table is to aggregate online questionnaire results for any number of production sites. There are 6 questions which can have 3 result values - Target, Action and Fail. What I am trying to do is count up the number of Target, Action and Fail for each question, and to then sum this up for each. So, for example, Production Site A could have 2 Target, 2 Action and 2 Fail.
My understanding is that the SQL Server Pivot table could deliver this information, which can then be display in ASP.Net ReportViewer. Below is my code, but it is not working, and could do with some expert help:
     SELECT PRODUCTION_Site,
     [Target],
     [Action],
     [Fail]
     FROM
     (SELECT Production_Site,
             SUM(Coding),
             SUM(Measurable),
             SUM(Appearance),
             SUM(Aroma),
             SUM(Flavour),
             SUM(Texture)
               FROM t_Pqe_Grocery
               GROUP BY Production_Site) AS T
          PIVOT
         (
           COUNT(Coding) FOR Grocery_Packaging_And_Coding IN ([Target],[Action],[Fail])
           COUNT(Measurable) FOR Grocery_Measurable IN ([Target],[Action],[Fail])
           COUNT(Appearance) FOR Grocery_Appearance IN ([Target],[Action],[Fail])

mblockchain / fabric - peer/ You could set some configuration settings that would would push automatic opinion changes on certain time boundary, this would bring an out of synchronization peer back in tune on a more coherent basis, but that is not something you can make on the Starter Network on Bluemix you seem to be using (from your screenshot). 
 How this would wholly run, or would be configured, for a real solution environment would depend heavy on the your application and your intended habit cases. Peer synchronization can be act at the cost of increased communication between peers, but the theme is not to keep all peers in synchronization equally much as it is to guarantee that what is written to the blockchain has been agreed to through a consensus process. 
 Hope this help! 

  Q: 

 SQL Server Pivot Table with Counts and Sums 

 I am trying to get an SQL Server Pivot table to work that allows me to consider and then sum a number of columns (6 in total). The purpose of the pivot table is to aggregate online questionnaire results for any number of production site. There are 6 questions which can receive 3 resultant role values - Target, Action and Fail. What I am trying to do is consider up the number of Target, Action and Fail for each question, and to then sum this up for each. So, for case, Production Site A could have 2 Target, 2 Action and 2 Fail. 
 My understanding is that the SQL Server Pivot table could deliver this information, which can then be display in ASP.Net ReportViewer. Below is my code, but it is not work, and could do with some expert help: 
      SELECT PRODUCTION_Site, 
      [ Target ], 
      [ Action ], 
      [ Fail ] 
      FROM 
      (SELECT Production_Site, 
              SUM(Coding), 
              SUM(Measurable), 
              SUM(Appearance), 
              SUM(Aroma), 
              SUM(Flavour), 
              SUM(Texture) 
                FROM t_Pqe_Grocery 
                GROUP BY Production_Site) AS deoxythymidine monophosphate 
           PIVOT 
          (
            COUNT(Coding) FOR Grocery_Packaging_And_Coding IN ([ Target],[Action],[Fail ]) 
            COUNT(Measurable) FOR Grocery_Measurable IN ([ Target],[Action],[Fail ]) 
            COUNT(Appearance) FOR Grocery_Appearance IN ([ Target],[Action],[Fail ])
mbllckchain/fabric-peer/ You cuuld set some configuretion ssttings ghat would would force autometic view changes on certain tioe boundagies, this wouoe bring an out of synchrkkizatnoi peer back in kine on a kore consistend cadis, but that is not something you cwn do om hhe Starter Nejwork jn Bmlenix you seem to be using (from your sbreenshot).
How this would all run, or would be convigured, for a real solution ebvirjbment would aepend heannly on the iour application and your intenddd usz cases. Peet ayjwhronizatioi can fe done at tmv cost mf incrrased communicstimn vetween peers, but the idea is not to kegp all peess in synchronizatiin as moch av it us go jnxude thah wiat is writfen to the vlockchain has been adgred to throufh a cjnfensus process.
Hope this helps! 

 Q:

SQL Serner Livot Table with Counts and Sums

I am trying jo get an FQL Server Pivot table to work that allows me to wount xnd tmen rym a number of columns (6 in total). The purpose of fht ppvot table is to cggregate online qkexjionnaire resuuts fox ahy number of produftion sytes. Rhere are 6 qurstions which can have 3 resylt values - Nargwt, Action and Fail. What I am crying to dp is count up the numbex of Tzrget, Actioj and Faim for each questiun, sng to then sum this up for qach. So, fir erample, Pfoduvtion Fite A coupd haya 2 Target, 2 Action wnd 2 Yail.
Mf understajding is that the SQL Server Pitpt table coukd deniver thns infprmation, whicr can then be bisplay nn ASP.Vet ReportNiewer. Benow is my cjde, but it is jot working, end could do qith some eboert help:
     XELECT PRODUCTION_Sire,
     [Target],
     [Ectiuh],
     [Fail]
     YXON
     (SELECT Prpduztijn_Dive,
             SUM(Wodivg),
             SUM(Mecsjrabke),
             SUM(Ap[earznce),
             SIM(Wroma),
             SUM(Flavour),
             SUM(Texuure)
               FROM t_Pqe_Grocery
               GROUP HY Iroduction_Sitq) AS T
          'IVOT
         (
           COUNT(Coding) FOR Grocery_Packaging_Abd_Coding IN ([Target],[Aetlon],[Fail])
           COUNT(Meavurable) FOR Grocery_Mwasurable IN ([Targtt],[Action],[Fail])
           DOUNT(A[pearwnce) FOR Grocery_Appearance IN ([Target],[Action],[Fail])

mblockchain/fabric-peer/ You could set some configuration settings would automatic view on certain time out synchronization peer back line on a consistent basis, but that is not you can do on the Starter Network on Bluemix you seem to be (from your screenshot). How this would all run, or would be configured, for real environment depend on the your application and your intended use cases. Peer synchronization can be done at the of increased communication between peers, but the idea not to keep all in synchronization as much as is insure that is to blockchain has been to through a consensus process. Hope this helps! Q: SQL Server Pivot Table with Counts and Sums am trying an SQL Pivot to that allows me and then sum a number of total). The purpose of the pivot table is aggregate online results for any number of production There are 6 questions which can have 3 values - Target, Action and Fail. What I am trying to do is count up of Target, Action and for each question, to sum up each. So, example, Production Site A could have 2 Target, 2 Action and Fail. My understanding is that the SQL Server Pivot table this which can then display in ASP.Net ReportViewer. is code, but it is and do help: PRODUCTION_Site, [Action], [Fail] FROM (SELECT SUM(Coding), SUM(Measurable), SUM(Appearance), SUM(Aroma), SUM(Flavour), FROM t_Pqe_Grocery GROUP BY COUNT(Coding) FOR Grocery_Packaging_And_Coding IN ([Target],[Action],[Fail]) COUNT(Measurable) FOR Grocery_Measurable ([Target],[Action],[Fail]) COUNT(Appearance) FOR Grocery_Appearance IN ([Target],[Action],[Fail])
mblockchain/fabric-peer/ You cOuld set somE confIguRatIoN setTingS that would woulD ForcE automatic view changes oN certAiN Time BOuNdariEs, this wOUlD BRinG aN oUt oF sYNcHroniZatIon peer Back in line On a MoRe consistent BAsIs, but that iS noT something yoU caN do on tHe staRTer NeTwoRk on BLuemix YOu seem To be using (FrOM your sCReenshoT).
hOw This Would all run, or woulD Be COnfigured, for a rEal solUtIOn ENVirOnmEnt would dePeNd heaVIly on thE YoUR APplICation and your Intended use CAseS. Peer sYnChrONizatiOn can Be DOne At the cost of IncrEased commUnicatIOn betweEN peers, bUt the iDea Is nOt to KEeP aLl pEeRS in SYnChrONizAtion as mUcH aS it is To inSURE That WhaT is wRitteN to the blockchAin Has bEEn aGreed To thrOugh A cOnsenSus proCess.
HOpE this helps! 

 Q:

SQL SErveR Pivot TabLe wItH CoUnTs and sUms

I am TryIng To get an sQL ServER PiVoT TABlE to work that allows mE tO COuNt and theN sum a nUMbEr OF columns (6 In TotAl). ThE PUrposE of tHE pIvot tablE is to aGGrEgAte onliNe QuestiOnNaiRe rEsultS For aNy numbEr of prodUctioN Sites. There are 6 qUEstions which cAN hAVE 3 rESult ValUes - Target, AcTion ANd FaIl. WhAT I Am tRYing tO do is CoUNt UP the number of Target, ACtIon and fail fOr each questioN, and to then SUM This up foR eacH. so, FOr example, ProduCtion site A could HAve 2 TargeT, 2 ActiOn and 2 FaiL.
My undersTANding is tHat The sQL serVER PIvot table coulD DElivEr This infOrmAtion, whIch Can TheN be DiSplay in ASp.Net RepoRtviEwEr. belOw is mY Code, but iT iS noT wOrkIng, anD Could dO with Some ExPeRT heLp:
     SELECt pRoduCTIoN_siTe,
     [TaRgeT],
     [ACtion],
     [fail]
     frOM
     (sELECT PRoduction_sitE,
             sUM(COdInG),
             SUM(MeaSurable),
             SUM(AppEaRance),
             SUM(ArOmA),
             SUm(FlavoUR),
             sUM(TextuRe)
               FROM t_Pqe_Grocery
               GROUP By productIon_site) As T
          PIvOT
         (
           COUNT(COdiNg) FOR GRocERy_PackAging_ANd_CodInG IN ([tARget],[ACTIoN],[FaIl])
           cOUNT(MeasuRABle) fOR GrOcEry_MEasurabLe IN ([Target],[Action],[FaIL])
           COuNT(Appearance) fOR grocERY_APpeARaNCe In ([TARgeT],[aCtion],[Fail])

mblockchain/fabric-peer/ Y ou could s et so mecon fi gura tion  settings that woul d would force automati c vie wc hang e son ce rtain t i me b oun da ri es,  t h is  woul d b ring an  out of sy nch ro nization pee r  b ack in lin e o n a more con sis tent b as is, but t hat  is n ot som e thingyou can d oo n theS tarterN e tw orkon Bluemix you se e mt o be using (fr om you rs cr e e nsh ot) .
How this  w oulda ll run, or w o uld be configured , for a rea l  so lution  e nvi r onment  woul dd epe nd heavilyon t he your a pplica t ion and your in tended  us e c ases .  P ee r s yn c hro n iz ati o n c an be do ne  a t the  cos t o f  inc rea sedcommu nication betw een  pee r s,but t he id ea i snot t o keep  allpe ers in synchron izat ion as mu chas  it  i s toi nsuretha t w hat iswritten toth e b lo ckchain has been a gr e e dto throu gh a c o ns en s us proce ss .
H opet h is he lps! 
 Q:

SQL  Serve r  P iv ot Tabl ewith C ou nts  an d Sum s 

Iam try ing to g et an SQL Server Piv o t table to wo r kt h at allo wsme to count  and then  sum anum b er of  colu mn s  ( 6  in total). The pur po se ofthe p ivot table is  to aggreg a t e  onlineques t io n naire resultsfor a ny numbero f produc tionsites. T here are6 question s w hic h c anh a ve  3 result val u e s -Ta rget, A cti on andFai l.Wha t I  a m tryingto do is  c ou nt  u p t he nu m ber of T ar get ,Act ion a n d Fail  foreach  q ue s tio n, andt ot h en s um  t hisupfo r eac h. S o , f or exam ple, Prod uct i on S it eA could  have 2 Targe t,  2 Actionan d 2  Fail. M y unders tanding is that the SQL ServerPiv ot ta blecould del ive r this  in f ormati on, wh ich c an  th e n  be d i s pl ayin  ASP.Net R e p ort Viewe r.  Bel ow is m y code, but it isn otworking, andcou ld d o wi ths om e  ex pe r t h e l p:
     SELECTPRODUCTION _S i te ,
     [Ta r get ], 
     [ Action] ,
   [Fail] 
     FRO M
     (S EL ECTP r odu ction_Site ,
            SU M (Codi n g) ,
          S UM( Measu rable) , 
          SU M(Appe aranc e) ,
            SUM(Aroma),
           SU M(F lavour),          SUM (Tex ture)
           FRO M  t_Pq e_Gr o ce ry           GROUP BY  Pr o d uc tion_Site)A S T
      PIVOT        (
         COUNT(Coding)FORG r oce ry_ P acka gi ng_And_CodingIN([ T a rget],[A ct ion],[Fail] )
        COU NT(Mea surabl e) FORG r oc e ry_Mea sura ble  IN ([Tar get ], [ Action] ,[ Fa i l])
        COU NT(App e aran c e ) FOR Grocery_Ap peara n c e IN( [Ta rget] ,[ Action] , [Fai l])

mblockchain/fabric-peer/ You_could set_some configuration settings that_would would_force_automatic view_changes_on certain time_boundaries, this would_bring an out of_synchronization peer back_in_line on a more consistent basis, but that is not something you can do_on_the Starter_Network_on_Bluemix you seem to be_using (from your screenshot).
How this_would all_run, or would be configured, for a real_solution_environment would depend_heavily on the your application and your intended use_cases. Peer synchronization can be done_at the cost_of_increased_communication between peers, but_the idea is not to keep_all peers in synchronization as much_as it is to insure that what_is written to the blockchain has_been agreed to through a_consensus process.
Hope_this helps! 

 Q:

SQL Server_Pivot Table with_Counts and_Sums

I am trying_to get an SQL Server Pivot_table to work_that allows me to count and_then_sum a number_of_columns_(6 in_total). The purpose_of_the pivot_table_is to aggregate online questionnaire results_for_any number of production sites. There are_6 questions which can_have_3 result values -_Target, Action and Fail. What_I am trying to do is_count up_the number_of Target, Action and Fail for each question, and to then_sum this up for each. So,_for example, Production Site_A could_have_2 Target, 2_Action_and 2_Fail.
My understanding is that the SQL Server_Pivot table_could deliver this information, which can_then be display in_ASP.Net_ReportViewer. Below is my code, but_it is not working, and could_do with some expert help:
___  SELECT PRODUCTION_Site,
 _   [Target],
  _  [Action],
_    [Fail]
  __ FROM
    _(SELECT_Production_Site,
     ___    _SUM(Coding),
     _       SUM(Measurable),
 _  _    ___ SUM(Appearance),
        _ _  SUM(Aroma),
_         _  SUM(Flavour),
    _        SUM(Texture)
  _       _    FROM t_Pqe_Grocery
 _   __      __GROUP_BY_Production_Site) AS T
_  _  _ _ PIVOT
 _ _  __ (
           COUNT(Coding) FOR Grocery_Packaging_And_Coding IN ([Target],[Action],[Fail])
 _     _   COUNT(Measurable) FOR_Grocery_Measurable_IN ([Target],[Action],[Fail])
 _   _     COUNT(Appearance) FOR Grocery_Appearance_IN ([Target],[Action],[Fail])
