Thank you for your help.

Kind Regards

I understand,

Is there any particular website you would suggest to have a look how to create SSRS with images, please?

Also I have a concern that some of the clients may...

Thank you for the reply.

Do you think it would be a good approach for automated processes, which might be invoked by end-user

from an application?

Kind Regards

Kumar-386306 (6/15/2013)

---

Exactly said. checking SAN is in progress now and expecting our Storage guys to see any abnormal settings done.

BTW. Could you please let me know what SAN Setting was...

Thanks for the ideas!

In terms of auditing we thought as well that SQL is better, but the customer insists they do better auditing within their 4G application.

Thanks again

I know how to work with statistics in Oracle.

In MSSQL I hope this one will help:

http://stackoverflow.com/questions/1328506/how-do-you-gather-statistics-from-sql-server

Priceless!

Thank you

Have you ran any statistics on your database?

How about your transaction log? Do you maintain it properly?

I am not a DBA either, but this what I would look first.

Oh no !!!! :blush:

It is pretty embarrassing! I didn't think about the update option at all it works like a charm with a minor change - ORDER BY ParentId, Id!

Massive...

Please allow me try to explain Salesforce' logic, as I understand it:

(1) each of the objects has an Id field, which is a string of 18 characters.

(2) number of objects...

Sorry - 1 level only

You're correct - the values for #oldAccount.newId and #oldAccount.newParentId will come from #newAccount.Id and #newAccount.ParentId respectively. An only common field between the two tables is Name

Thank you

I need to update newId and newParentId of #oldAccount with Id and ParentId of #newAccount respectively.

At the moment I'm only able to update #oldAccount table with newId and only for...

Point taken - have updated my original post

Finally they will have what Oracle had delivered ages ago....