Home Forums SQL Server 2005 T-SQL (SS2K5) TSQL Return start/end price and start/end datetime by product name. RE: TSQL Return start/end price and start/end datetime by product name.

  • 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]