Query Syntax - Ordering, Labels, Numbering

I have a query that pulls a small subset of values (names of assessment forms) from a large table containing lots of names we do not need.
I am using this query to create a drop down list for a report filter that I need to build.  I want to do "get from query", using this results set in specifying the filter's Available Values.
Query appears below.  How can I modify the syntax to end up where the choices appear in the order I want? I am assuming I'll need a label with numbering to make the list appear as shown below.

What I want to end up with is a results set that looks like so:
1. Consumer Needs Assessment
2. Nutritional Risk Assessment
3. Caregiver Assessment
4. Individual Client Contact Form
5. Public and Media Event Recording

I don't really care about showing or having the numbers appear in the drop down this will create unless I need them to force or support the ordering.

Here's the query:
HAR_ASSESSMENTS.ASSESSFORM_NAME
FROM
  HAR_ASSESSMENTS
WHERE
  HAR_ASSESSMENTS.ASSESSFORM_NAME = N'AAA Consumer Needs Evaluation'
    OR HAR_ASSESSMENTS.ASSESSFORM_NAME = N'Nutritional Risk Assessment'
    OR HAR_ASSESSMENTS.ASSESSFORM_NAME = N'Caregiver Assessment Form'
  OR HAR_ASSESSMENTS.ASSESSFORM_NAME = N'Individual Client Contact Form'
  OR HAR_ASSESSMENTS.ASSESSFORM_NAME = N'Public and Media Activity Recording'
GROUP BY
  HAR_ASSESSMENTS.ASSESSFORM_NAME
gberkeleyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ephraim WangoyaCommented:

Seems you already know the data you want to display so why do you need to select from a table

select N'AAA Consumer Needs Evaluation'
union all
select N'Nutritional Risk Assessment'
union all
select N'Caregiver Assessment Form'
union all
select N'Individual Client Contact Form'
union all
select N'Public and Media Activity Recording'
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HainKurtSr. System AnalystCommented:
addition to what ewangoya posted

select * from (
select 1 id, N'AAA Consumer Needs Evaluation' ASSESSFORM_NAME
union all
select 2, N'Nutritional Risk Assessment'
union all
select 3, N'Caregiver Assessment Form'
union all
select 4, N'Individual Client Contact Form'
union all
select 5, N'Public and Media Activity Recording'
) x order by id
0
gberkeleyAuthor Commented:
Thanks for the lightning fast response!!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.