I want to extend my query to get the Minimum Date and Time with Maximum Date and Time

ID xSymbol MaxDate MaxTime MinDate MinTime

1 MSFT 101 77 ...

Thanks, That works!...

J Livingston SQL (7/22/2012)

---

its probably only one of many ways.....only...

Thank's, I like your solution and I never would have thought of it.

I added a join of the StockQuote with #TempSymbolList to produce...

I found the problem. I need brackets...

GilaMonster (7/21/2012)

---

SELECT @info = STUFF(( SELECT ', ' + 'MAX([' + TempSymbol + ']) As ['+ TempSymbol + ']'

FROM #TempSymbolList

FOR XML PATH('')...

I'm not sure I know what you mean?

Thank you so much! That works great

Thanks, clayman and vinus! Both solutions worked with the exception of one maybe not so small point. I did not get the symbols in the header. Is this...

vinu512 (6/5/2012)

---

Yes We can tweak it.

--Static Pivot

Select xDATE, Max(MSFT), MAX(AAPL), MAX(AMD) From

(Select xDATE, [MSFT], [AAPL], [AMD] From

(Select A.* From StockQuote as A

JOIN #TempSymbolList as B ON A.xSymbol = B.TempSymbol)...

vinu512 (6/5/2012)

---

Is this what you have i mind?

--Static Pivot

Select xDATE, [MSFT] As CloseSymbol1, [AAPL] As CloseSymbol2, [AMD] As CloseSymbol3 From

(Select A.* From StockQuote as A

JOIN #TempSymbolList as B ON...

Evil Kraig F (6/5/2012)

---

The method you want is either a Crosstab query or the PIVOT function, but the problem with both of those is you typically want to know how...

This will create a table of the stock data, I stripped out everything but the close ( no open,high low)

USE [StockQuoteDB]

-- create the stock Quote Table

CREATE TABLE [dbo].[StockQuote](

[ID] [int] IDENTITY(1,1)...

dwain.c (5/28/2012)

---

You can try something like this:

SELECT t3.SYMBOL, t3.COMPANY

FROM @TABLE1 t1

INNER JOIN @TABLE2 t2 ON t1.SYMBOL = t2.SYMBOL

CROSS APPLY (SELECT SYMBOL, COMPANY FROM @TABLE2 t3 WHERE t2.SECTOR = t3.SECTOR) t3...

Yes you are correct. I edited the original post.