You’re offline. This is a read only version of the page.
2,050
Greeting everyone
by using while select i'm really confused to how create a query by x++ for my request?
i have this table
i have tow request from this table i don't know get it by x++ select
1-i need employees which have only (Plan==PlanA && Status==Open) must this employees doesn't have another different row
and the result should be
(Katey , Ben)
others will be ignored because they have more than this satiation Plan and Status
2-i need employees which have only (Plan==PlanB && Status== Close )must this employees doesn't have another different row
and the result should be
(Sara)
others will be ignored because they have more than this satiation Plan and Status
i really try many select but all gone wrong how can i do that also i did used group by but still not give me the result which i need?
Record record;
Record notExistsRecord;
-- first case
select record
where record.Plan=='PlanA'
&& record.Status=='Open'
notexists join notExistsRecord
where record.Plan == notExistsRecord.Plan
&& record.RecId != notExistsRecord.RecId;
--second
select record
where record.Plan=='PlanB'
&& record.Status=='Closed'
notexists join notExistsRecord
where record.Plan == notExistsRecord.Plan
&& record.RecId != notExistsRecord.RecId;
Share
Report
All responses (
Answers (
