メモのバックアップ(No.3)

[2016/08/26 14:14:40,341],[INFO ],[29],2,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-1,period_e=2013-2,
[2016/08/26 14:14:56,555],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-2,period_e=2013-3,
[2016/08/26 14:15:05,549],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-3,period_e=2013-4,
[2016/08/26 14:15:06,858],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-4,period_e=2013-5,
[2016/08/26 14:15:11,251],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-5,period_e=2013-6,
[2016/08/26 14:15:13,322],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-6,period_e=2013-7,
[2016/08/26 14:15:16,276],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-7,period_e=2013-8,
[2016/08/26 14:15:27,959],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-8,period_e=2013-9,
[2016/08/26 14:15:32,730],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-9,period_e=2013-10,
[2016/08/26 14:15:38,290],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-10,period_e=2013-11,
[2016/08/26 14:15:42,468],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-11,period_e=2013-12,
[2016/08/26 14:16:45,770],[INFO ],[29],1,0,[commandText]: select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;  [commandParameter]:enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-12,period_e=2014-01,

commandText

select answerid as Key, count(*) as Value from "answers" where "enterpriseid" = @enterpriseid AND "storeid" = @storeid AND "deviceid" = @deviceid AND "screenid" = @screenid AND "datetime" >= @period_s and "datetime" < @period_e group by answerid order by answerid;

commandParameter

enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-1,period_e=2013-2,
enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-2,period_e=2013-3,
enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-3,period_e=2013-4,
enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-4,period_e=2013-5,
enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-5,period_e=2013-6,
enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-6,period_e=2013-7,
enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-7,period_e=2013-8,
enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-8,period_e=2013-9,
enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-9,period_e=2013-10,
enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-10,period_e=2013-11,
enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-11,period_e=2013-12,
enterpriseid=1,storeid=0,deviceid=0,screenid=501,period_s=2013-12,period_e=2014-01,

メモ のバックアップ(No.3)

覚書(TODO) †

DDL †

コントロールタイプ †

その他 †

フラグ初期化タイミング †

集計処理 †

SQL †

ｘ年の集計（月ごと） †