Click here to Skip to main content
15,914,444 members
Home / Discussions / Database
   

Database

 
Questionhelp SQL query Pin
trungysp198625-Aug-17 16:06
trungysp198625-Aug-17 16:06 
GeneralRe: help SQL query Pin
PIEBALDconsult25-Aug-17 18:18
mvePIEBALDconsult25-Aug-17 18:18 
AnswerRe: help SQL query Pin
Member 133967936-Sep-17 13:58
Member 133967936-Sep-17 13:58 
QuestionConvert or use expression in Sql select statement Pin
indian14323-Aug-17 13:49
indian14323-Aug-17 13:49 
AnswerRe: Convert or use expression in Sql select statement Pin
David Mujica24-Aug-17 4:03
David Mujica24-Aug-17 4:03 
AnswerRe: Convert or use expression in Sql select statement Pin
ZurdoDev24-Aug-17 4:50
professionalZurdoDev24-Aug-17 4:50 
QuestionSSIS Package creating XML Pin
Member 1335791511-Aug-17 19:59
Member 1335791511-Aug-17 19:59 
AnswerRe: SSIS Package creating XML Pin
jschell14-Aug-17 8:28
jschell14-Aug-17 8:28 
Member 13357915 wrote:
It's lists all odd numbered records first then all the even numbered ones.


Why is that a problem?

Member 13357915 wrote:
so I cannot see why this is happening.


Assuming ordering perhaps. If you are not explicitly ordering the records then you are assuming the ordering. There is no assurance of ordering. It might normally be ordering (default ordering) by the primary index and that might change with a cluster.
Questionsql Query help Pin
venu6568-Aug-17 23:53
venu6568-Aug-17 23:53 
AnswerRe: sql Query help Pin
Richard MacCutchan9-Aug-17 0:19
mveRichard MacCutchan9-Aug-17 0:19 
AnswerRe: sql Query help Pin
Richard Deeming9-Aug-17 1:19
mveRichard Deeming9-Aug-17 1:19 
GeneralRe: sql Query help Pin
venu6569-Aug-17 17:54
venu6569-Aug-17 17:54 
GeneralRe: sql Query help Pin
Richard Deeming10-Aug-17 0:49
mveRichard Deeming10-Aug-17 0:49 
QuestionSQL boolean comparison Pin
User 1106097926-Jul-17 21:25
User 1106097926-Jul-17 21:25 
AnswerRe: SQL boolean comparison Pin
Richard MacCutchan26-Jul-17 22:03
mveRichard MacCutchan26-Jul-17 22:03 
GeneralRe: SQL boolean comparison Pin
User 1106097926-Jul-17 22:40
User 1106097926-Jul-17 22:40 
GeneralRe: SQL boolean comparison Pin
Richard MacCutchan26-Jul-17 22:48
mveRichard MacCutchan26-Jul-17 22:48 
JokeRe: SQL boolean comparison Pin
User 1106097926-Jul-17 23:14
User 1106097926-Jul-17 23:14 
GeneralRe: SQL boolean comparison Pin
User 1106097927-Jul-17 22:40
User 1106097927-Jul-17 22:40 
GeneralRe: SQL boolean comparison Pin
Richard MacCutchan27-Jul-17 22:59
mveRichard MacCutchan27-Jul-17 22:59 
GeneralRe: SQL boolean comparison Pin
Member 133967936-Sep-17 14:04
Member 133967936-Sep-17 14:04 
AnswerRe: SQL boolean comparison Pin
Mycroft Holmes26-Jul-17 22:23
professionalMycroft Holmes26-Jul-17 22:23 
GeneralRe: SQL boolean comparison Pin
User 1106097926-Jul-17 22:42
User 1106097926-Jul-17 22:42 
AnswerRe: SQL boolean comparison Pin
Richard Deeming27-Jul-17 1:41
mveRichard Deeming27-Jul-17 1:41 
GeneralRe: SQL boolean comparison Pin
User 1106097927-Jul-17 1:53
User 1106097927-Jul-17 1:53 

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.