Return results from view with an extra row

#1

I have a view that returns rows from a table and would like to add an
extra row to the result set, but don't want to add that row in the
table. How do I do this?

My view returns:

Mickey
Minnie
Donald

I'd like the view to return but don't want "NA" added to the table:

Mickey
Minnie
Donald
NA

Thanks.

#2

emanning wrote:

Quote:

I have a view that returns rows from a table and would like to add an
extra row to the result set, but don't want to add that row in the
table. How do I do this?

My view returns:

Mickey
Minnie
Donald

I'd like the view to return but don't want "NA" added to the table:

Mickey
Minnie
Donald
NA

It's called a "union" query:

select disneycharactername from disneycharacters
union all
select top 1 'NA' from disneycharacters

This has to be entered in SQL View.

#3

Bob Barrows wrote:

Quote:

This has to be entered in SQL View.
Oops, I thought I was in the Access group - of course, this bit is not

relevant to SQL Server.

#4

emanning wrote:

Quote:

I have a view that returns rows from a table and would like to add an
extra row to the result set, but don't want to add that row in the
table. How do I do this?

My view returns:

Mickey
Minnie
Donald

I'd like the view to return but don't want "NA" added to the table:

Mickey
Minnie
Donald
NA

aargh, and my suggested query was relevant to JetSQL, not T-SQL. In T-SQL,

one does not need a FROM clause so my suggestion can be simplified to:

select disneycharactername from disneycharacters
union all
select 'NA'

#5

On Jan 14, 10:02*am, "Bob Barrows" <reb01... (AT) NOyahooSPAM (DOT) com> wrote:

Quote:

emanning wrote:
I have a view that returns rows from a table and would like to add an
extra row to the result set, but don't want to add that row in the
table. *How do I do this?

My view returns:

* * *Mickey
* * *Minnie
* * *Donald

I'd like the view to return but don't want "NA" added to the table:

* * *Mickey
* * *Minnie
* * *Donald
* * *NA

aargh, and my suggested query was relevant to JetSQL, not T-SQL. In T-SQL,
one does not need a FROM clause so my suggestion can be simplified to:

select disneycharactername from disneycharacters
union all
select *'NA'

Got it! Thanks, Bob.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Return results from view with an extra row

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Return results from view with an extra row - 01-14-2011 , 09:51 AM

Re: Return results from view with an extra row - 01-14-2011 , 09:59 AM

Re: Return results from view with an extra row - 01-14-2011 , 10:00 AM

Re: Return results from view with an extra row - 01-14-2011 , 10:02 AM

Re: Return results from view with an extra row - 01-14-2011 , 10:15 AM