Employee TotalTime xxx xxx xxx this is my requirement please help me to out get out of this problem
(comments are locked)
|
|
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/
(comments are locked)
|
Your answer
I am afraid the information provided is too little too vague. If you expect help then post more details.
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?