parikiti (4/12/2013)

---

sorry for the late reply...

Case 1:the first column can be considered as first one and also there is a time assigned when the that particular row was created like 04/01/2013 6:30:00AM ...something along those lines

Case 2: i emant when we are comparing two rows with the same customer name and also those rows if they have same createdBy like in the sample Cris is repeated as the one who created that row...

example :

RowID CustomerName CustomerID CreationDate CreatedBy Validation

row 1 Vam 000245 04/01/2013 6:30:00am Cris

row 2 Vam 000245 04/01/2013 7:45:00am Cris

These two have the same customerName and same CreatedBy then the difference between the CreationDate should be greater Than the Lock_Count Value which we get from Table ParametersB.

After the process is done The CustomerA should like this

RowID CustomerName CustomerID CreationDate CreatedBy Validation

1 Vam 000245 04/01/2013 Cris 8(as this was created first)

2 Vam 000245 04/01/2013 cris 9(a row exists for time frame)

3 Vam 000245 04/02/2013 cris 8(first row for new time frame)

4 Vam 000245 04/01/2013 ted 9(Already exists and different created by)

8-Means that row is valid;

9-Means that row is invalid

hope this helps

These two have the same customerName and same CreatedBy then the difference between the CreationDate should be greater Than the Lock_Count Value which we get from Table ParametersB.