Can you please give send me a piece of code which does that ?

Here is my history table

auditid | idUser | firstname | lastname | auditaction |audittime

1 | 1 | aaaa | bbbb | I| 1/2/2012

2 | 1 | aaaa | cccc |U...

I already have the data in history table. Its just that I need to present them in client required format.

To achieve this I need to get the previous row value...

Thanks to all here.... It was a very good discusssion... SQL Server central rocks 🙂

Thanks.. Thats what i was looking for. Can you explain little more about tie breaker process.

Just to clear it again

There will be only one paper.

First this data will be entered by one user (First pass). He might do some mistakes in entering.

Later the same data...

Is there any way to improve this.

I was thinking of creating two different tables and consolidating the data and make sure that which is the right data ?

Thanks for the suggestion.

But i need to create a feature to the user through which user should not be doing any manual validation of the fields. There wil two differet...

It should be possible. Its a requirement. This feature is called as double data entry and through this if another user enters same data then it should tell him...

The table look like this

TableName : Test

Here are the Columns

idTest - Unique column

idPatNum - Patient Id number

idVisit - Visit ID

col1 - Questionnaire 1 which will be asked by...

But i am getting below error for one of the column which has 82 columns

Cannot create index or statistics 'IX_LABREPORT' on table 'LABREPORT' because the computed column 'cs_LABREPORT' is imprecise...

Hi all,

I am able to define checksum column and do the job .

Thanks to all.

Anand

CAn anybody help me in defining checksum column ?

MAny Thanks

No. There is no candidate key which can replace this.

Is that link tells me about defining unique key for checksum of mulitple columns.

I did not understand how that works ?

Do i need to check table for the...