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 |
|
rds207
Posting Yak Master
198 Posts |
 Posted - 2009-08-03 : 13:41:04
|
| Iam sorry for the confusion,let me make it bit clear I have a table ec_build, which has the details about no of agents allocated for a particular type of build,and the class id of that build etcI have another table which has the no of agents being utilized for particualr type of build,now i want the output from 2 tables into one result having columns like built type,allocated agents,utilized agents basically i want to know how many resources are being utilized by a single built........ |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-08-03 : 13:46:18
|
I read it again and again but sorry I am not able to understand 
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-08-03 : 14:01:34
|
Radhika,You need to understand that we dont have access to your data... quote:
details of agents utilized and allocated agents allocated categorizing by build class type
This makes no sense to us, unless we know your data.Please provide some sample data and expected output for a solution. |
|
|
|
rds207
Posting Yak Master
198 Posts |
Posted - 2009-08-03 : 14:39:14
|
Iam sorry for the confusion,let me make it bit clear I have a table ec_build, which has the details about no of agents allocated for a particular type of build,and the class id of that build etcI have another table which has the no of agents being utilized for particualr type of build,now i want the output from 2 tables into one result having columns like built type,allocated agents,utilized agents basically i want to know how many resources are being utilized by a single built........quote:
Originally posted by vijayisonly
Radhika,You need to understand that we dont have access to your data... quote:
details of agents utilized and allocated agents allocated categorizing by build class type
This makes no sense to us, unless we know your data.Please provide some sample data and expected output for a solution.
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-08-04 : 03:12:17
|
something like this (replace tables/columns with actual names):-select t1.build_type,t1.allocatedagents,t2.utilizedagentsfrom ec_build t1join table2 t2on t2.build_type_id=t1.build_type_id |
|
|
|
|
|
|
|
|
Please help ASAP