15,895,142 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by emilio1979 (Top 2 by date)
emilio1979
29-May-19 2:15am
View
hi, hereby the top 10 query on the Original table:
dateTimeColumn locationColumn parameterColumn valueColumn unitColumn flagColumn commentColumn qualifierColumn dateTimeOrgColumn
2019-02-12 01:45:00.000 0400CLUSTER 0400_FT1100_MTW 125.011 m3/h 1 Meetwaarde 100.00 2019-02-12 01:45:00.000
2019-02-14 05:15:00.000 0400CLUSTER 0400_FT1100_MTW 85.868 m3/h 1 Meetwaarde 100.00 2019-02-14 05:15:00.000
2019-02-18 14:30:00.000 0400CLUSTER 0400_FT1100_MTW 709.544 m3/h 1 Meetwaarde 100.00 2019-02-18 14:30:00.000
2019-02-21 21:15:00.000 0400CLUSTER 0400_FT1100_MTW 902.572 m3/h 1 Meetwaarde 100.00 2019-02-21 21:15:00.000
2019-02-25 07:30:00.000 0400CLUSTER 0400_FT1100_MTW 595.224 m3/h 1 Meetwaarde 100.00 2019-02-25 07:30:00.000
2019-03-01 23:30:00.000 0400CLUSTER 0400_FT1100_MTW 546.001 m3/h 1 Meetwaarde 100.00 2019-03-01 23:30:00.000
2019-03-06 14:45:00.000 0400CLUSTER 0400_AT1330_MTW 4.802 g/l 1 Meetwaarde 100.00 2019-03-06 14:45:00.000
2019-03-06 14:45:00.000 0400CLUSTER 0400_AT1340_MTW 2.633 mg/l 1 Meetwaarde 100.00 2019-03-06 14:45:00.000
2019-03-06 15:00:00.000 0200CLUSTER 0240_LT1010_MTW 19.173 % 1 meetwaarde 100.00 2019-03-06 15:00:00.000
2019-03-06 15:00:00.000 0200CLUSTER 0250_LT1010_MTW 31.361 % 1 meetwaarde 100.00 2019-03-06 15:00:00.000
emilio1979
28-May-19 9:05am
View
hi, thnx for the reply,
here som extra data:
0200_P1511_TPV 27 762
0200_P1521_TPV 27 2492
0200_P3010_TPV 27 2927
0200_P3020_TPV 27 2337
0200_P1511_TPV 26 1206
0200_P1521_TPV 26 2605
0200_P3010_TPV 26 2675
0200_P3020_TPV 26 3286
0200_P1511_TPV 25 951
0200_P1521_TPV 25 2569
0200_P3010_TPV 25 3002
0200_P3020_TPV 25 2635
0200_P1511_TPV 24 851
0200_P1521_TPV 24 2539
0200_P3010_TPV 24 2195
0200_P3020_TPV 24 3262
0200_P1511_TPV 23 781
0200_P1521_TPV 23 2563
0200_P3010_TPV 23 3083
0200_P3020_TPV 23 2340
0200_P1511_TPV 22 943
0200_P1521_TPV 22 2545
0200_P3010_TPV 22 2311
0200_P3020_TPV 22 3095
i would like to get the data sorted by day not every sample per day:
so totals per day like this:
sum off samples day 27 27 8518
sum off samples day 26 26 9772
sum off samples day 25 25 9075
sum off samples day 24 24 9481
sum off samples day 23 23 9772
sum off samples day 22 22 9157