Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Adding a "pseudo record" to a view.

Posted on 2011-03-02
2
Medium Priority
?
356 Views
Last Modified: 2012-08-13
I have a view, something like:

SELECT DISTINCT Salesman FROM SalesReport

This gives me the proper list.  However, I need to add one record that does not exist in the SalesReport table, that is "--ALL--"  (It's for an issue with Crystal Reports, if you really need to know)

Can I do this?  How?
0
Comment
Question by:Clif
2 Comments
 
LVL 32

Accepted Solution

by:
Ephraim Wangoya earned 2000 total points
ID: 35017914

SELECT DISTINCT Salesman FROM SalesReport
union all
SELECT '--ALL--'
0
 
LVL 10

Author Closing Comment

by:Clif
ID: 35017986
Ever have one of those days when the obvious escapes you?

Thanks for jarring my memory.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to shrink a transaction log file down to a reasonable size.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question