Hassle-free live chat software re-imagined for business growth. 2 users, always free.
This selects the data from the tblEquipment correctly and creates two new columns 'Ok1' and 'Ok2'
SELECT (SELECT Ok1 = case Latitude when '-' then '0' when '' then '0' else '1' end) as Ok1, (SELECT Ok2 = case Longitude when '-' then '0' when '' then '0' else '1' end) as Ok2 FROM tblEquipment
WHERE Ok1='1' AND Ok2='1'
|T-SQL: Why do the single quotes make a difference for a date field?||5||35|
|How can i get data when i use where clause with group by?||3||20|
|How to get time difference in minutes and seconds only between 2 dates||2||19|
SQL 2012 update fails repeatedly : the UPdate is SQLServer2012-KB3194721-x6
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!