ASC Result Set with Nulls at the bottom

I have a results set that is sorted on LineNum. Not all items have a
LineNum (some are null). I want my result set to return all items in
ASC LineNum order and then list all items with NULL LineNum at the end
of the results. Any Suggestions?

Thanks.On 25 Jan 2006 12:22:36 -0800, ActiveX wrote:

>I have a results set that is sorted on LineNum. Not all items have a
>LineNum (some are null). I want my result set to return all items in
>ASC LineNum order and then list all items with NULL LineNum at the end
>of the results. Any Suggestions?

Hi ActiveX,

ORDER BY CASE WHEN LineNum IS NULL THEN 1 ELSE 0 END, LineNum

--
Hugo Kornelis, SQL Server MVP

Arrange Items in Solution Explorer

Can the items, i.e. reports within the SSRS Report Designer Solution Explorer be arranged in a custom manner instead of being sorted alphabetically only?

Hi.

The reports in the solution explorer are ordered alphabetically when you open a solution/project; when you add them to an open solution/project they tend to be added just to the end.

I dont know of any way to change the default ordering, but as workaround you could just add a number prefix to the title of each report (e.g. 01-This report is top.rdl, 02-Another report.rdl etc.) so they are ordered in the way you want.

Hope this helps,

Gary.

|||Hi Gary,

Thanks for the reply.

I really want to avoid changing the report object names. Perhaps I will just leave it for now since it is just a cosmetical issue anyway.

Thanks again.

Kenny

Arrange Items in Solution Explorer

Can the items, i.e. reports within the SSRS Report Designer Solution Explorer be arranged in a custom manner instead of being sorted alphabetically only?

Hi.

The reports in the solution explorer are ordered alphabetically when you open a solution/project; when you add them to an open solution/project they tend to be added just to the end.

I dont know of any way to change the default ordering, but as workaround you could just add a number prefix to the title of each report (e.g. 01-This report is top.rdl, 02-Another report.rdl etc.) so they are ordered in the way you want.

Hope this helps,

Gary.

|||Hi Gary,

Thanks for the reply.

I really want to avoid changing the report object names. Perhaps I will just leave it for now since it is just a cosmetical issue anyway.

Thanks again.

Kenny

Arrange Items in Solution Explorer

Can the items, i.e. reports within the SSRS Report Designer Solution Explorer be arranged in a custom manner instead of being sorted alphabetically only?

Hi.

The reports in the solution explorer are ordered alphabetically when you open a solution/project; when you add them to an open solution/project they tend to be added just to the end.

I dont know of any way to change the default ordering, but as workaround you could just add a number prefix to the title of each report (e.g. 01-This report is top.rdl, 02-Another report.rdl etc.) so they are ordered in the way you want.

Hope this helps,

Gary.

|||Hi Gary,

Thanks for the reply.

I really want to avoid changing the report object names. Perhaps I will just leave it for now since it is just a cosmetical issue anyway.

Thanks again.

Kenny