httpwwwcheggcomhomeworkhelpquestionsandanswersqgivenstatedis

http://www.chegg.com/homework-help/questions-and-answers/q-given-state-display-sum-balances-state-use-procedure-tables-needed-customer-table-create-q16878951

my question pertains to this scenario and i want to know: when using a procedure the system should be able to add new customers ensuring that no duplicates are entered and the type is valid. I am having trouble writing the procedure

Solution

To identofy the duplicate and then remove the same can be understand as through this example:-

Consider an example:-

Create a table EmpDtl1 with some duplicate rows as shown below to understand different methods of delete duplicate rows.

User Name \"Andy\" repeated 2 times and User Name \"Bill\" repeated 3 times.

Now see, how we can handle the situation of removing the duplicate entries:-

Insert the distinct rows from the duplicate rows table to new temporary table. Delete data from table which has duplicate rows then insert the distinct rows from the temporary table as shown below.

Hope it help!!