MS-SQL 7.0, sqsh, not returning null values
Bill Doulass
bill at tcada.state.tx.us
Thu Feb 17 11:10:05 EST 2000
When I run a query that returns null and non-null values for a field, each
row that contains a null field is overwritten with the previous non-null
value for that field.
Example:
sqsh 1.7, compiled on Red Hat Linux 6.1, talking to MS SQL 7.0.
When I query address1 and address2 fields, address2 returns null until it
hits a row that contains a non-null value. Thereafter, it returns the
previous non-null value.
1> select addr_line_1, addr_line_2 from dOffender_Ed_Site where county='El
Paso'
2> go
addr_line_1 addr_line_2
------------------------------ ------------------------------
P.O. Box 370173
215 Willow
701 Montana Ave.
P.O. Box 370173
P.O. Box 370173
701 Montana Ave. - Norton Room
701 Montana Ave. - Norton Room
10622 Montwood Dr., Suite D
7665 Leconte
7665 Leconte
7665 Leconte
7665 Leconte
P.O. Box 370173
10536 Montwood Dr., Ste. B
7665 Leconte
215 Willow
10737 Gateway W., Ste. 108
The Center Building 2104 E. Yandell, Ste. D-5
701 Montana Ave. - Norton Room 2104 E. Yandell, Ste. D-5
2104 E. Yandell, Ste. D-5 2104 E. Yandell, Ste. D-5
701 Montana Ave. - Norton Room 2104 E. Yandell, Ste. D-5
10737 Gateway W., Ste. 108 2104 E. Yandell, Ste. D-5
10536 Montwood Dr., Ste. B 2104 E. Yandell, Ste. D-5
The Center Building 2104 E. Yandell, Ste. D-5
Travel Lodge Hotel 409 E. Missouri
10737 Gateway W., Ste. 108 409 E. Missouri
701 Montana Ave. - Norton Room 409 E. Missouri
The Center Building 2104 E. Yandell, Ste. D-5
9005 Dyer, Ste. 106 2104 E. Yandell, Ste. D-5
10737 Gateway West, Ste. 108 2104 E. Yandell, Ste. D-5
10536 Montwood Dr., Ste. B 2104 E. Yandell, Ste. D-5
4625 Alabama St. 2104 E. Yandell, Ste. D-5
4625 Alabama St. 2104 E. Yandell, Ste. D-5
Any suggestions are greatly appreicated.
BTW - the snapshot seems much more stable than 0.5 - thanks for the help in
getting that compiled.
More information about the FreeTDS
mailing list