>>Hi,
>>I would like to create a SQL Server command that would set a column to a value and at the same time set the value before the change.
>>
>>For example, say I have a table PartTable and I want to update the value of column INSTOCK to some value of the variable @StockQty but first set the value of this column to another variable, @StockQtyBeforeChange. This is the UPDATE part of the desired statement:
>>
>>
>>update PartTable set instock = @StockQty where inv_code = @InvCode
>>
>>
>>but I cannot see how to add the following into the statement above:
>>
>>
>>select @StockQtyBeforeChange = instock from PartTable where inv_code = @InvCode
>>
>>
>>Is it possible to do what I am thinking? TIA
>
>Look into OUTPUT clause for UPDATE command in order to set variables of before and after values (Deleted and Inserted tables).
Did you see what Hugo suggested? And thank you for your suggestions.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham