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 |
|
anuragvatsa
Starting Member
6 Posts |
 Posted - 2010-01-04 : 02:24:44
|
| Hi am a newbie to sql query.So, How to write a query teh scenariao is as follows.--project estimated effort, actual effort spent,%usage of project Effort,%completion Of project and Ratio of % work completion to % effort consumed for during the given perod and cunulative YTD(total effort till last day of privious month). Note: the every type of effort has to fetched from diffrent tables.ThanksEagle A.and please suggest me any books on report generation from multiple tables. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-04 : 02:57:54
|
| Seems like a homework question. B/w can you post some sample data and explain? |
 |
|
|
anuragvatsa
Starting Member
6 Posts |
Posted - 2010-01-04 : 05:34:24
|
quote:
Originally posted by visakh16
Seems like a homework question. B/w can you post some sample data and explain?
quote:
Reply by Eagle A.
:-) Ya, it was and finally did it with help from some forum. thanks a lot for ur quick reply. But i need some help in form of some tutorials or so to genrate these kind complex queries involving cursors n all which enhance my skills to work more efficiently.Thanks again in advance.;-)
|
|
|
|
|
|
|
how to write select query