Thank you

Thank you Erland Sommarskog.

I got the same link.

I was curious about its impact. Whether I have to generate and embed it to app or just install it and it may...

Thank you.

I was so confuse as on internet people are saying binary_checksum cannot guarantee to find differences but hashbyte is much accurate.

As we have seen examples , it seems it...

thank you britton.

Following worked. I was not aware that XML column becomes case sensitive while selecting.

DECLARE @testXml XML;

set @testXml=

'<invoices>

...

Thank you Lutz.

I will take care of oracle stuff, just...

I have used 2nd option but having following error....

Thank you Lutz.

RPC with Execute worked.

second option you have mentioned is use to insert records in Oracle from local MSSQL object ?

a free tool with option to customize

http://www.apexsql.com/sql_tools_refactor_features.aspx

Phil Parkin (12/23/2013)

---

You could also try forcing transaction commits in your WHILE loop:

WHILE @@rowcount > 0

BEGIN

begin tran

INSERT INTO tblPricingExc2 --table tblPricingExc2 has an Identity column as PK.

( Key ,

Flag ,

Id

)

SELECT...

Thanks Phil.

Begin and Commit tran worked. Does this avoid logging ?

I have insert and Update . No delete required.

Phil,

I have done so, but have same results.

Jeff Moden (8/30/2012)

---

It's been several years since I've had to work with OPENQUERY but I believe the following will work...

select <stuff ...>

from OPENQUERY(Banner_Prod, 'SELECT a.Major

,a.FIRSTNAME AS NameFirst

,a.MIDDLENAME AS NameMiddle

,a.LASTNAME AS...

not a secrete 🙂

I have product related data in database. one of the ex.dev wrote query to fetch results in 3 with top1 as I mentioned. Now I have got...

yes, but I have to add some other conditions and they worked with your logic 🙂

I would thank you both for valuable suggestions

Thank you Sean Lange, it worked 🙂