question

mvramana avatar image
mvramana asked

how to get total working time of a day with all weekdays in sqlserver 2008

## Monday## Tuesday Wednesday Thursday Friday Saturday Sunday ---------- date date date date date date date ---------- Employee TotalTime Name ---------- xxx xxx xxx this is my requirement please help me to out get out of this problem
stored
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

robbin avatar image robbin commented ·
I am afraid the information provided is too little too vague. If you expect help then post more details.
3 Likes 3 ·
Magnus Ahlkvist avatar image Magnus Ahlkvist commented ·
To elaborate on robbin's comment: In which tables is the information stored today, and what do they look like? Do you just want to get the information out from a query or are you aiming at producing a pretty Report in Reporting Services?
1 Like 1 ·

1 Answer

·
Jeff Moden avatar image
Jeff Moden answered
Please see the following URL which explains how to do this and is easily modified to do it by the dates you want. [ http://www.sqlservercentral.com/articles/Crosstab/65048/][1] [1]: http://www.sqlservercentral.com/articles/Crosstab/65048/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.