Add value to return result set.

Question

Post reply

Add value to return result set.

ronaldkrex

Right there with Babe

Points: 768
More actions
February 5, 2010 at 1:31 pm

#220417

I was wondering if I can contruct a stored procedure that can add a value to to resultset. In my case I would like to add the value 'ALL' Thanks for any help.

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Lynn Pettis

SSC Guru

Points: 442467

February 5, 2010 at 1:34 pm

#1114751

Care to show us what you asking?

ronaldkrex Right there with Babe Points: 768 More actions · Answer 2

Yes like i said I have a stored procedure that I execute to return a resultset. This resultset is simply to provide a list of states to the user.However there is a value that is not in the returned resultset that i need. For Example the value ALL.

LutzM SSC Guru Points: 107049 More actions · Answer 3

Try to use UNION or UNION ALL statement. (For details please see BOL or provide some more details on what you're trying to do).

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

No, that isn't what I asked for. Show what you are trying to accomplish. What code have you written so far, and you actually want.

ronaldkrex Right there with Babe Points: 768 More actions · Answer 5

Select * from States. Then I want to add the value ALL to the resultset.

ronaldkrex Right there with Babe Points: 768 More actions · Answer 6

So it sounds like i would need to create a new table just to hold the value ALL?

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

ronaldkrex (2/5/2010)
Select * from States. Then I want to add the value ALL to the resultset.

Not really sure if you want this:

select 'ALL',StateName from States

or this

select StateName from States

union all

select 'ALL'

Hard to tell as you haven't shown what you want.

ronaldkrex Right there with Babe Points: 768 More actions · Answer 8

Thanks it worked great however I lost my column name. Can you tell me how to rename it from No column name to depatment.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

Lynn Pettis

SSC Guru

Points: 442467

February 5, 2010 at 2:32 pm

#1114793

Show me your code.

ronaldkrex Right there with Babe Points: 768 More actions · Answer 10

select 'ALL'

union all

SELECT distinct Department FROM dbo.tblReportData

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 11

ronaldkrex (2/5/2010)
select 'ALL'
union all
SELECT distinct Department FROM dbo.tblReportData

select 'ALL' as Department

union all

SELECT distinct Department FROM dbo.tblReportData

ronaldkrex Right there with Babe Points: 768 More actions · Answer 12

I was just going to tell you I figure it out. You have Been very very helpful. Thank you so much. What do I do to vote for you or give you credit for answering my question?

WayneS SSC Guru Points: 95461 More actions · Answer 13

ronaldkrex (2/5/2010)
I was just going to tell you I figure it out. You have Been very very helpful. Thank you so much. What do I do to vote for you or give you credit for answering my question?

This web site doesn't work that way... we've evolved:w00t:

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2