-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Dhaksagi
Message 1 in Discussion
Hai friends, Please help me with this cos I have been struggling with this
for quite a long time. I need to write a stored procedure to compare 2 tables.
Both the tables consists of rows of cities with entities such as Address and
Phone. So for each city there many be n number of entities. The rows in the
tables are like City 1 C
City 1 C Address11 A
Address12 A Phone11 P
Phone12 P Address12 A Phone
12 P City 2 C
City22 C Address21 A
Address21 A Phone 21
P Phone 21 P
Address 22 A Phone 22 P The
Criterias are the cities, Address, Phone - any of them can be deleted,
modified. Or inserted. I want to find the deleted rows in the Table1 and mark
them in Table 2 where they have been exactly deleted. For eg in Table 2, the
rows have a column with value 'P' or 'N' to indicated whether the previous row
or the next line has been deleted. Some of the other conditions that prevail
are 1. All the entities in a city can be deleted, and the city alone remains,
in that case the city in the Table 2 has no of entities deleted in that city 2.
All the entities and the city can be deleted, so either the previous row or the
next row of the city shld have the value of deletion The same way,
the modification and insertion also, The cities can be moved from one position
to another along with their entities. that has to be found out and mentioned in
the modifications also. So pls friends, give me some suggestions regarding
this.. Thanks in Advance for ur help.. Thanks, Dhaks
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
