Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amitranjan
Starting Member
45 Posts |
 Posted - 2010-12-31 : 06:30:46
|
| Hi I have 6-7 tables. In each table there is a common entity called fisherid. I have four fields in each table that is CreatedBy, createdDate, LastModifiedBy and LastModifiedDate. These fields are keeping track of last operation date and user name on that table. Now the problem is that i need to show history of fisher, that is what a user done on a particular fisher. I have 3 columns in my grid that is ActivityDate, UserName and Description. What i need is to display something like thisActivityDate User Description------------ ----------- ---------------------------11/12/2010 Test User Updated Address12/12/2010 Alexander Created NoteLet me explain you the above. If in a table say address if a user Test User updates any field then the query must be able to say your address field has been updated or can pull the action based on lastmodified date and lastmodifiedbyuser field(if they are not null or blank). Similar for all tables. If CreatedBy and CreatedDate are null then no history will be displayed.I hope the scenario is clear.amit Ranjan |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2010-12-31 : 07:48:59
|
Not clear, post the DDL structures and sample data and sample results to get better help.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
|
|
|
Wrapping Multiple Columns to Single Column