Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bhdijkstra
Starting Member
24 Posts |
 Posted - 2011-04-28 : 07:35:46
|
| i have a line of 10 days which is in total 240 hours. i want to know how to calculate this into the working hours per working day also known that there is a table with a workingschedule. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-04-28 : 07:37:13
|
| Please post your table structure, some sample data, and the expected results. |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-04-28 : 07:38:44
|
| Seehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=160018Again I would consider converting this into a row per hour then joining to the schedule table to get the working hours.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
bhdijkstra
Starting Member
24 Posts |
Posted - 2011-04-28 : 07:46:44
|
| I want to have this resultParameter Manager, Parameter Month:left side table: all employees of the managertop table: item code, scheduled hours and total hoursinside: hours made that monththe program is Exact Synergy Enterprise, but does this really matter? |
|
|
|
|
|
|
dividing a datetraject into the real working days