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

avatar 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/

more ▼

answered Jun 16, 2012 at 04:41 AM

avatar image

Jeff Moden
1.9k 3 7 12

(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.

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: 3278 times

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

Copyright 2016 Redgate Software. Privacy Policy