Ok. I will check.

Thanks alot

Disha

I have implemented that, but looks like performance of the report rendering is not good. As I am generating single pdf for several beneficiaries.

Thank you very much

Disha.

Hi,

I have created non_clusted indexes on the columns that I am using in the update query.

now is fine. Now running in 30 sec.

But in the testdb(databasea) does not indexes,but still...

Hi lowell, and steve

It looks like this synonym concept is woking for me. I would have asked this question a couple months back.

I am very much greatful to you.

Disha.

Hi Mike,

Thank you very much for you reply.

In my case I am inserting and updating about 4-5 table. I might insert update 5 thousand rows and might update about...

Ok. I will try it out as you said.

Thanks alot for your help

Disha

Thanks for your reply.

But I did not get exacly, could you plz give an simple example..

Thanks alot

disha

($0.00) FY1FY2FY3FY4

Net revenue$10,003$20,876$25,000$28,000

Gross Revenue$12,000$24,000$15,000$12000

col1 and col2 col3 are revenue columns, like net and gross revenues in the dollor amounts.