Active and Cancelled

[ravindraa]

Hi all,

  we have two databases 1 have contracts based on status wise (ACTIVE,CANCELLED,ENROLLED,NA) as well as 2 database also like that  but both data base doesn't have same contracts ex:one data base have 69 contracts 2 data base have 35 contracts we need to differentiate that i mean the value is 35 . here we need to show 35 all contracts in one particular table.

so far i did to find up-to difference value i am struck to  find the particular 35 contracts, if any one knows please give me suggesion.

i have attached the doc. please find those. i have

it is very urgent if any one knows please give me any suggestion.

[Anonymous]

PFA

In this way you can find what contracts are available in Talisma and what are in SAP file and what are available in both.

Moreover if it is not your req, then please ellaborate more.

Regards

Nitin

[ravindraa]

Hi Nitin Gupta,

   Thanks for reply we want difference value list i mean as far the my dash board

talisma have 69

sap have       34

difference  is 35

if we select 35 all 35 contracts should be display or which is different contract and those contract maintain separate table.

please give me any suggestion.

[Anonymous]

you ca use not exists function to extract the difference data and then you can easily store them into new table.

use where not exists (contracts)

[ravindraa]

Hi Nitin Gupta,

   using that we are not getting value, if we use that condition we are getting '0' value .

please give me any suggestion.

[#6]

Hi PFA as per my understanding.