sql - How to avoid datepart to start from new week on year change -

-

i have sql query using weekly data. works fine when year changes stops week on 4 days or whatever , starts new week new year. dont want that. want keep working like before. idea of how force group datepart(week, ad.xdate)

select 'playing' activity  ,min(ad.xdate) xdate ,isnull(sum(t.timeperday),0) timeperday     alldates ad (nolock)  left join @test t on ad.xdate = t.date group datepart(week, ad.xdate)    order min(ad.xdate) option (maxrecursion 0) 

group     datediff(week, 0, ad.xdate)

Comments

Post a Comment

Popular posts from this blog

angular ui router - 10 digest iterations reached in angularjs when using $state.go -

-
i using angular ionic. i not want user have login again in case logged in , did not logout last time used application. reason, using local storage check if user logged in. tried putting code in run block. $rootscope.$on('$statechangestart', function (event, tostate, toparams, fromstate, fromparams) { if($localstorage.userinfo){ $state.go('deployment'); //this line 270 of app.js event.preventdefault(); return; } }) but gives error says: rangeerror: maximum call stack size exceeded @ scope.$broadcast (ionic.bundle.js:23414) @ object.transitionto (ionic.bundle.js:40804) @ object.go (ionic.bundle.js:40671) @ app.js:270 @ scope.$broadcast (ionic.bundle.js:23412) @ object.transitionto (ionic.bundle.js:40804) @ object.go (ionic.bundle.js:40671) @ app.js:270 @ scope.$broadcast (ionic.bundle.js:23412) @ object.transitionto (ionic.bundle.js:40804) also, error: [$rootscope...
Read more

javascript - Can Piwik report referrer in real time? -

-
i looking query piwik api in real-time stats on current visitor. example, have javascript file that'd i'd fetch piwik api json info on visitor using page contains javascript file (referrer, mobile/desktop, location etc.) as far understand piwik must have data generate analytics on per-user basis. fear might not allow querying info in way i've described above. if that's case, can obtain pw? api method better, if not i'd use same system make real-time reports 1 use generate stats on groups of users particular 1 belongs to. according api page , piwik live! widget refreshes every 5 seconds, , displays new visits. each visitor, can see: date number of actions time spent on site country browser operating system whether visitor new or returning visit the referrer used access site (search engine & keyword, campaign, or referrer website) whether visitor converted goal you can query live! api module , use live.getlastvisitsdetails method ...
Read more

asp.net - Google Drive Access: At least one client secrets (Installed or Web) should be set -

-
we have tested demo code of google drive (for console application) , went correct, after trying implement same web application @ present hosted @ localhost. application giving exception: an exception of type 'system.invalidoperationexception' occurred in google.apis.auth.dll not handled in user code additional information: @ least 1 client secrets (installed or web) should set the code trying run this: usercredential credential; googleclientsecrets s= new googleclientsecrets(); s.secrets.clientid="xxxxxxxxxx-xxxxxxxx.apps.googleusercontent.com"; s.secrets.clientsecret="yyyyyyyyyyyyyyyyyyyyy"; credential = googlewebauthorizationbroker.authorizeasync(s.secrets,scopes,"user",cancellationtoken.none,null).result; var service = new driveservice(new baseclientservice.initializer() { httpclientinitializer = credential //applicationname = applicationname, }); ...
Read more