hi,
how to write query to select project estimated effort,actual effort spent,%usage of project effort,%complet ion of project,ratio of %work completion to % effort consumed FOR
1. during the period
2. Cumulative period
All the differnt kind of effort comes from multiple tables
thanks
Eagle A,
anuragvatsa
Last Activity: Jan 4 '10, 09:14 AM
Joined: Dec 29 '09
Location:
-
Query for report generation from multiple tables
-
anuragvatsa started a topic Stored procedures for selecting the data from databse & displaying on selctionin MySQLStored procedures for selecting the data from databse & displaying on selction
Hi,
I have 4 columns workID, Description, work & Rework . On the basis these four columns i have to generate four more columns as total Work,%work, %Rework, %Total Work. we have some dummy data. So Now my question is how to write stored pocedure to select in case of the above scenaraio.
Thnks. -
how to write select query
please help me to write a query in which i have to genrate report on basis of given columns from different tables.
am using sql server 2005
thx & regards -
How to add data from two coloumns
Hi all, well am new to SQL.
There is a scenario, where i have to add values from two coloumns selected on the basis on particular ID and then add the total or average values of the resulted column.
Am using SQL SERVER 2005 developer edition.
and how to calculate percentage of each row of a column based on Particular ID
AND YES I HAVE TO WRITE THE SELECT QUERY FOR THE ABOVE SCENARIO.
THANKS
No activity results to display