<div>
Select empid, storeid, sum(hours) from<br />
(Select empid, storeid, Case when punchout is null then 0 else<br />
DateDiss(hours , punchin, punchout) end as hours from employee)A <br />
group by empid, storeid
</div>


Select empid, storeid, sum(hours) from
(Select empid, storeid, Case when punchout is null then 0 else
DateDiss(hours , punchin, punchout) end as hours from employee)A
group by empid, storeid

<div>
<div class="content wysiwyg-content">
HI all,<br />
i have table with<br />
employeeid number<br />
timein datetime<br />
timout datetime<br />
<br />
how can i calculate total punched hours. how can i calculate it timeout is null<br />
<br />
the sample data i am giving.<br />
empid &nbsp; storeid &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;punchin &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;punchout <br />
2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2007-07-18 18:44:26.897 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NULL<br />
95 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2007-08-22 17:20:04.373 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NULL<br />
2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2007-08-21 08:00:00.000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2007-08-21 10:00:00.000<br />
2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2007-08-21 20:43:17.387 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2007-08-22 11:08:40.343<br />
59 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2007-10-02 15:10:00.000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2007-10-02 18:56:44.973<br />
62 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2007-09-08 09:15:00.000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2007-09-08 19:30:00.000<br />
62 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2007-09-17 09:21:00.000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2007-09-17 17:00:00.000<br />

</div>
</div>


HI all,
i have table with
employeeid number
timein datetime
timout datetime

how can i calculate total punched hours. how can i calculate it timeout is null

the sample data i am giving.
empid   storeid	punchin			punchout 
2	1	2007-07-18 18:44:26.897	NULL
95	1	2007-08-22 17:20:04.373	NULL
2	5	2007-08-21 08:00:00.000	2007-08-21 10:00:00.000
2	5	2007-08-21 20:43:17.387	2007-08-22 11:08:40.343
59	7	2007-10-02 15:10:00.000	2007-10-02 18:56:44.973
62	7	2007-09-08 09:15:00.000	2007-09-08 19:30:00.000
62	7	2007-09-17 09:21:00.000	2007-09-17 17:00:00.000


sql 2005 query

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.