Engr Shafiq (2/21/2012)
@TheSQLGuru:
But there is issue like when some one is updating middle record?for example max id is 10 but i want to edit id=5 then this query l not work?why we are using timestamp is for this....
Actually i want to clear you about my question
i am saving or updating records first time and then updating image field after this.both operations are not cary in one query...
Now I really don't understand your requirements. Table definitions, sample data, sample data flow with expected results please. Or hire someone to help you due to the complexity of what you are trying to accomplish. Past a certain level of complexity forums are useless for solving problems.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service