x

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
more ▼

asked Jun 12, 2012 at 01:11 PM in Default

mvramana gravatar image

mvramana
0 2 2 3

I am afraid the information provided is too little too vague. If you expect help then post more details.
Jun 13, 2012 at 04:38 AM robbin
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?
Jun 13, 2012 at 05:48 AM Magnus Ahlkvist
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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/
more ▼

answered Jun 16, 2012 at 04:41 AM

Jeff Moden gravatar image

Jeff Moden
1.8k 3 4 8

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x11

asked: Jun 12, 2012 at 01:11 PM

Seen: 1967 times

Last Updated: Jun 16, 2012 at 04:41 AM