Order by View

Question

Situation ..

I need to order the NAME field. But this field has values ​​NULLS.

How can this sort with a VIEW?

[] s

Answer 1

Hello,

You can order by that column, even if it contains NULL values. So where is exactly the problem?

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

The problem is this, see the example
Name  | Phone
   A     | 555 555
  null   | 666666
   A     | 777 777
   B     | 555 555

This [null] should not appear. It should be ordered as follows:
. A
. A
. B

Answer 3

If you do not want those NULLS then simply restrict them using the where clause !  that is what the where clause works.

 Try

 

CREATE TABLE YOURTABLE(NAME VARCHAR(10), PHONE VARCHAR(20))

INSERT INTO YOURTABLE VALUES('A',12121)
INSERT INTO YOURTABLE VALUES('B',12122)
INSERT INTO YOURTABLE VALUES(NULL,12124)
SELECT Name,Phone FROM YOURTABLE WHERE NAME IS NOT NULL ORDER BY NAME

---

Thanks
Manish

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 4

the problem that if you run the select from view within SSMS, the fields do not appear nulls.
they appear only in view of the report.

Answer 5

Hi Bruno,

In your case, I think that we can add a filter to eliminate null values on the report level and then sort the report column. For example, we can add a filter like this:
Expression: =IsNothing(Fields!Name.Value)OR (Fields!Name.Value="")
Operator: =
Value: =False

For more information, please see:
Add a Filter: http://technet.microsoft.com/en-us/library/ms156270(v=sql.100).aspx
Sort Data in a Data Region: http://technet.microsoft.com/en-us/library/ms157462(v=sql.100).aspx

Regards,
Bin Long

---

Bin Long

TechNet Community Support