Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
SQL help needed
My table has something like below: Projectid projectoppdesc statusid updateddate oper 111 my proj. 1 4/2006 I 111 your proj. 1 4/2006 U Here Projectoppdesc has been updated, so the new value will be "your proj." and the old... -
SQL help needed
You are right. There is a corresponding row with I. That date prompt was an error. -
-
SQL help needed
My table project has 20 columns. One of the column called 'operation' has 'U' for Update and 'I' for Insert showing that something has been updated or inserted in that particular row. I have to compare the rows and show both what the old value was and the new value that was updated is. So my...
