Hi,

Thanks for your replies. But I need to perform for multiple tables in single package.

Thanks,

Anitha

Thanks for your reply.

The property set for protection level is "EncryptSensitiveWithUserKey"

Hi Adrian,

Sorry to not mentioning the date format before.

The different formats present in table are

...

Hi Adrian

Thanks for the query.

Can you please tell me...

Thanks a lot Ramesh.

It really helped me lot..

Can any 1 give me the same result using joins

Thanks,

Anitha.

Thanks a lot suresh and vaidyanathan.

But i need the result as mentioned ,could u pls help

Thanks,

Anitha

Hi,

As I above mentioned i got 1 idea and the query is written below

SELECT count(Customer_id) FROM Customer WHERE CountryCode='vn'

UNION ALL

SELECT COUNT(salesOp_id) FROM SalesOp WHERE programCode='lt' and SalesOfficeCode like 'vn%'

The...