What about if the price changes back to the same value as it was before:
INSERT INTO #Temp (Name ,Price ,Date)
SELECT 'ProductA', 10.45, '1/June/2010 07:00'
Do you want another record to appear in your results?
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]