Phil, Chris,
Indeed no discussion regarding the use of target variables.
The point is, will its content be correct during the setbased work
if the variable is used more then once in the statement.
Suppose you have more than one price ....
(cfr result data for select from views containing an order by ( before the 'fix' and trace) )
For now it seems to work with correct results, but ... you have to
figure out how to force the process order.
I'm glad Jeff cleared it out in this article :w00t:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me