JanOlMajti
Last Activity: Apr 2 '12, 07:36 AM
Joined: Feb 3 '12
Location:
-
The TableLayoutPane l may be a better solution for you - it has built in support for auto-sizing columns and rows, as well as auto-size for the whole panel -
Found the answer, pretty simple:
Select
_person_id, _project_id, date_of_hour, count(*)
from
myDataTable
where
_person_id = 'pe1'
and
date_of_hour between '13.10.2011' and '15.10.2011'
group by
_person_id, _project_id, date_of_hourLeave a comment:
-
How do i compare 2 rows from the same table (SQL Server)
Hello, i want to compare and count rows in the same datatabe.
myDataTable
hours_id(PK) | _person_id | _project_id | date_of_hour
-------------------------------------------------------
1 | pe1 | pr1 | 13.10.2011
2 | pe22 | pr1 | 13.10.2011
3 | pe1 | pr1 | 15.10.2011 *
4 | pe1 | pr1 | 13.10.2011...
No activity results to display
Leave a comment: