Viewing 6 posts - 1 through 6 (of 6 total)
I can divide question in two parts.
1. How i will be informed.
in this case, tempProducts will contain all the latest rows(newly added/updated rows). there will be no deleted row in...
June 22, 2008 at 10:29 am
bitbucket's code worked perfectly. thanks both of you for your help.
Regards,
Azam.
June 22, 2008 at 9:20 am
for
No, temp table don't contain alll records of orgininal table. it contains new inserted records + some of existing record with updated values.
Regards,
Azam.
June 22, 2008 at 4:12 am
Not tested,
but I think this kind of query can work....
--------------------------------
Update OriginalTable
set
OriginalTable.Field2=tempTable.field2,
OriginalTable.Field3=tempTable.field3
from tempTable
where OriginalTable.Field1=tempTable.Field1
------------
I was looking on OPENXML examples, when this idea comes in my mind. will test, will look forward...
June 20, 2008 at 5:25 pm
Thanks for the response.
1. I will compare 2 columns, ProductName and StoreName. Both table have equal number of fields with same names.
2. Can't provide all fields, there are almost 35...
June 20, 2008 at 4:44 pm
Hi,
I have same scenario, but with some addional option.
I have data in "temptable" and data in "originaltable".
What I want to do, I will insert all the new rows from "temptable"...
June 20, 2008 at 3:35 pm
Viewing 6 posts - 1 through 6 (of 6 total)