multiple select statements - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

multiple select statements

Author

Topic

cjsteury
Starting Member

2 Posts

Posted - 2008-01-13 : 10:01:28

Trying to run three select statements on one table...
the table is a list of Tickers with First and Last Dates

TICKERMASTER
Ticker FirstDate LastDate EOD
ABXA 1/12/2007 1/12/2008 No
AIRN 1/12/2007 1/12/2008 True
ALY NULL NULL No

I would like to return (using Select Statement?)
The TICKER and FIRST AND LAST columns which vary depending on whether 'EOD' is T or F.

I've tried GROUP BY and HAVING and can not get the three statements to run as one... any help is appreciated.... Here are the three statements...


SELECT TickerMaster.Ticker, Date()-365 as First
FROM TickerMaster
WHERE TickerMaster.LastDate IS NULL;
________________________________________________________

SELECT TickerMaster.Ticker, FirstDate as [First], TickerMaster.LastDate-1 AS [Last]
FROM TickerMaster
WHERE TickerMaster.LastDate <= Date() AND TickerMaster.EOD = FALSE;
_______________________________________________________________

SELECT TickerMaster.Ticker, FirstDate as [First], TickerMaster.LastDate AS [Last]
FROM TickerMaster
WHERE TickerMaster.LastDate <= Date() AND TickerMaster.EOD = TRUE;

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2008-01-13 : 10:31:02

UNION each select statement, is one way to go about it.



SELECT TickerMaster.Ticker, Date()-365 as First, NULL as [Last]
FROM TickerMaster
WHERE TickerMaster.LastDate IS NULL

UNION ALL

SELECT TickerMaster.Ticker, FirstDate as [First], TickerMaster.LastDate-1 AS [Last]
FROM TickerMaster
WHERE TickerMaster.LastDate <= Date() AND TickerMaster.EOD = FALSE

UNION ALL

SELECT TickerMaster.Ticker, FirstDate as [First], TickerMaster.LastDate AS [Last]
FROM TickerMaster
WHERE TickerMaster.LastDate <= Date() AND TickerMaster.EOD = TRUE

Poor planning on your part does not constitute an emergency on my part.

cjsteury
Starting Member

2 Posts

Posted - 2008-01-13 : 10:43:21

Thanks, DataGuru... works great, I knew there was an answer!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources