select statment .. throughing error

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

Other SQL Server Topics (2005)

select statment .. throughing error

Author

Topic

jayraj
Starting Member

2 Posts

Posted - 2009-04-04 : 03:30:32

DECLARE @varA INT
DECLARE @varB INT
SET @varA = 100;
SET @varB = 101;

SELECT * FROM (
(SELECT @varA AS varNumber)
UNION
(SELECT @varB AS varNumber))

i am trying above SQL code but it throughing error

please suggests solution

thank you very much
Jayraj

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-04-04 : 04:30:40

Missing alias for table

DECLARE @varA INT
DECLARE @varB INT
SET @varA = 100;
SET @varB = 101;

SELECT * FROM (
(SELECT @varA AS varNumber)
UNION
(SELECT @varB AS varNumber)) as t

Madhivanan

Failing to plan is Planning to fail

jayraj
Starting Member

2 Posts

Posted - 2009-04-04 : 04:59:57

Thank you very much,

quote:
Originally posted by madhivanan

Missing alias for table

DECLARE @varA INT
DECLARE @varB INT
SET @varA = 100;
SET @varB = 101;

SELECT * FROM (
(SELECT @varA AS varNumber)
UNION
(SELECT @varB AS varNumber)) as t

Madhivanan

Failing to plan is Planning to fail

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-04-04 : 06:08:41

quote:
Originally posted by jayraj

Thank you very much,

quote:
Originally posted by madhivanan

Missing alias for table

DECLARE @varA INT
DECLARE @varB INT
SET @varA = 100;
SET @varB = 101;

SELECT * FROM (
(SELECT @varA AS varNumber)
UNION
(SELECT @varB AS varNumber)) as t

Madhivanan

Failing to plan is Planning to fail

You are welcome

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources