Advertisement
Advertisement
| 09.17.2008 at 05:08AM PDT, ID: 23738169 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: |
select RelProj2Spec.childid taskId,
sum(record.animalcount) as used
from BaseRelation RelProj2Task inner join
record
on RelProj2Task.parentid = record.projectid inner join
BaseRelation Batch2Record
on record.id = Batch2Record.childId inner join
BatchTable
on Batch2Record.parentid = BatchTable.id inner join
activity
on Batchtable.id = activity.batchtechid inner join
BaseTable BTProj2Task
on RelProj2Task.id = BTProj2Task.id
where RelProj2Task.parentId = 4711 and
RelProj2Task.relationElementTypeId = 10 and
RelProj2Task.relationRecordStateId = 231 and
(relproj2Task.childid = activity.taskId or
relproj2Task.childid = activity.strainid) and
activity.sign = 0 and
activity.recordstateid = 231 and
BatchTable.recordstateid = 231 and
record.typeId = 12 and
record.State = 'ACTIVE' and
record.startdate >= case when BTProj2Task.typeId = 1
then to_date('1-Jan-1900')
else to_date('1-Jan-2008') end and
record.startdate <= to_date('26-Aug-2008') and
record.recordStateId = 231 and
Batch2Record.relationElementTypeId = 77 and
Batch2Record.relationRecordStateId = 231 and
BTProj2Task.elementTypeId = 10 and
BTProj2Task.recordStateId = 231
group by RelProj2Task.childid
|
