Click here to Skip to main content
12,635,232 members (25,170 online)
   

Database

 
AnswerRe: Older generation SQL syntax - Oracle Pin
Jörgen Andersson13-Feb-13 11:30
memberJörgen Andersson13-Feb-13 11:30 
GeneralRe: Older generation SQL syntax - Oracle Pin
vanikanc13-Feb-13 11:37
membervanikanc13-Feb-13 11:37 
AnswerRe: Older generation SQL syntax - Oracle Pin
Shameel15-Feb-13 5:17
memberShameel15-Feb-13 5:17 
QuestionHaving a bad SQL day Pin
TheComputerMan13-Feb-13 0:40
memberTheComputerMan13-Feb-13 0:40 
AnswerRe: Having a bad SQL day Pin
Jörgen Andersson13-Feb-13 1:20
memberJörgen Andersson13-Feb-13 1:20 
GeneralRe: Having a bad SQL day Pin
TheComputerMan13-Feb-13 1:32
memberTheComputerMan13-Feb-13 1:32 
GeneralRe: Having a bad SQL day Pin
Jörgen Andersson13-Feb-13 1:40
memberJörgen Andersson13-Feb-13 1:40 
GeneralRe: Having a bad SQL day Pin
Bernhard Hiller13-Feb-13 4:24
memberBernhard Hiller13-Feb-13 4:24 
By the way, 50 km is about half a degree. Depending on the amount of rows in your table, it might be wise to filter for longitude between -122.5 and -121.5 and latitude between 36.5 and 37.5 first.
Also a simple transformation with 110 km/degree for latitude, and 110 * cos(latitude) for longitude, and then using simple pythagoras might speed up the query.
GeneralRe: Having a bad SQL day Pin
TheComputerMan13-Feb-13 4:33
memberTheComputerMan13-Feb-13 4:33 
AnswerRe: Having a bad SQL day Pin
Shameel13-Feb-13 1:53
memberShameel13-Feb-13 1:53 
GeneralRe: Having a bad SQL day Pin
Jörgen Andersson13-Feb-13 1:56
memberJörgen Andersson13-Feb-13 1:56 
GeneralRe: Having a bad SQL day Pin
PIEBALDconsult13-Feb-13 5:01
memberPIEBALDconsult13-Feb-13 5:01 
GeneralRe: Having a bad SQL day Pin
Jörgen Andersson13-Feb-13 7:27
memberJörgen Andersson13-Feb-13 7:27 
QuestionWhat is Ado.net Pin
Himanshu Sharma 88812-Feb-13 20:20
memberHimanshu Sharma 88812-Feb-13 20:20 
AnswerRe: What is Ado.net Pin
Richard MacCutchan12-Feb-13 23:31
mvpRichard MacCutchan12-Feb-13 23:31 
GeneralRe: What is Ado.net Pin
Shameel13-Feb-13 1:44
memberShameel13-Feb-13 1:44 
GeneralRe: What is Ado.net Pin
Thomas Gabriel20-Feb-13 23:42
memberThomas Gabriel20-Feb-13 23:42 
AnswerRe: What is Ado.net Pin
Sandeep Mewara13-Feb-13 1:23
mvpSandeep Mewara13-Feb-13 1:23 
QuestionSQL 2008 Truncate vs Delete Pin
mrfalk12-Feb-13 7:47
membermrfalk12-Feb-13 7:47 
AnswerRe: SQL 2008 Truncate vs Delete Pin
Eddy Vluggen12-Feb-13 8:48
mvpEddy Vluggen12-Feb-13 8:48 
GeneralRe: SQL 2008 Truncate vs Delete Pin
mrfalk12-Feb-13 9:27
membermrfalk12-Feb-13 9:27 
GeneralRe: SQL 2008 Truncate vs Delete Pin
Eddy Vluggen12-Feb-13 9:36
mvpEddy Vluggen12-Feb-13 9:36 
GeneralRe: SQL 2008 Truncate vs Delete Pin
Khorshed Alam, Dhaka18-Feb-13 19:09
memberKhorshed Alam, Dhaka18-Feb-13 19:09 
AnswerRe: SQL 2008 Truncate vs Delete Pin
NickPace12-Feb-13 11:09
memberNickPace12-Feb-13 11:09 
AnswerRe: SQL 2008 Truncate vs Delete Pin
djj5513-Feb-13 4:59
memberdjj5513-Feb-13 4:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.161208.2 | Last Updated 10 Dec 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid