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

Database

 
QuestionHow can I optimize this SQL Query? Pin
Rafferty Uy4-Dec-08 17:52
MemberRafferty Uy4-Dec-08 17:52 
AnswerRe: How can I optimize this SQL Query? Pin
Wendelius4-Dec-08 19:38
mveWendelius4-Dec-08 19:38 
GeneralRe: How can I optimize this SQL Query? Pin
Rafferty Uy4-Dec-08 20:10
MemberRafferty Uy4-Dec-08 20:10 
GeneralRe: How can I optimize this SQL Query? Pin
Mycroft Holmes4-Dec-08 21:41
professionalMycroft Holmes4-Dec-08 21:41 
GeneralRe: How can I optimize this SQL Query? Pin
Wendelius4-Dec-08 21:59
mveWendelius4-Dec-08 21:59 
GeneralRe: How can I optimize this SQL Query? Pin
Wendelius4-Dec-08 21:58
mveWendelius4-Dec-08 21:58 
AnswerRe: How can I optimize this SQL Query? Pin
Ben Fair5-Dec-08 4:09
MemberBen Fair5-Dec-08 4:09 
GeneralRe: How can I optimize this SQL Query? Pin
Rafferty Uy8-Dec-08 17:18
MemberRafferty Uy8-Dec-08 17:18 
Hm.. I didn't know about the FAST FORWARD feature. Thanks for the tip.

Just to finalize this thread, will anyone be so kind to check if my optimized query above is correct (will give the same results as the old one)?


Thanks!

Rafferty

QuestionHow to access *.dbf file using c# Pin
Kumaran Jeyasingam4-Dec-08 14:32
MemberKumaran Jeyasingam4-Dec-08 14:32 
AnswerRe: How to access *.dbf file using c# Pin
PIEBALDconsult4-Dec-08 15:33
professionalPIEBALDconsult4-Dec-08 15:33 
AnswerRe: How to access *.dbf file using c# Pin
Mycroft Holmes4-Dec-08 21:45
professionalMycroft Holmes4-Dec-08 21:45 
GeneralRe: How to access *.dbf file using c# Pin
Wendelius5-Dec-08 8:24
mveWendelius5-Dec-08 8:24 
GeneralRe: How to access *.dbf file using c# Pin
Mycroft Holmes5-Dec-08 14:07
professionalMycroft Holmes5-Dec-08 14:07 
GeneralRe: How to access *.dbf file using c# Pin
Kumaran Jeyasingam14-Dec-08 14:58
MemberKumaran Jeyasingam14-Dec-08 14:58 
QuestionProgram Design - Master DataSet/Adapter for program? Pin
David Hovey4-Dec-08 8:53
MemberDavid Hovey4-Dec-08 8:53 
AnswerRe: Program Design - Master DataSet/Adapter for program? Pin
Wendelius4-Dec-08 9:25
mveWendelius4-Dec-08 9:25 
GeneralRe: Program Design - Master DataSet/Adapter for program? Pin
David Hovey4-Dec-08 10:56
MemberDavid Hovey4-Dec-08 10:56 
GeneralRe: Program Design - Master DataSet/Adapter for program? Pin
Wendelius5-Dec-08 7:50
mveWendelius5-Dec-08 7:50 
QuestionDatabase Problem Pin
sajjadlashari3-Dec-08 22:50
Membersajjadlashari3-Dec-08 22:50 
AnswerRe: Database Problem Pin
J4amieC3-Dec-08 23:08
MemberJ4amieC3-Dec-08 23:08 
AnswerRe: Database Problem Pin
Wendelius4-Dec-08 7:40
mveWendelius4-Dec-08 7:40 
QuestionNot able to see the Access database structure behind the form Pin
Brendan Vogt3-Dec-08 22:37
MemberBrendan Vogt3-Dec-08 22:37 
AnswerRe: Not able to see the Access database structure behind the form Pin
ChandraRam4-Dec-08 1:59
MemberChandraRam4-Dec-08 1:59 
AnswerRe: Not able to see the Access database structure behind the form Pin
Jerry Hammond4-Dec-08 6:36
MemberJerry Hammond4-Dec-08 6:36 
Questionproblem creating database role... Pin
rajkumar.33-Dec-08 22:33
Memberrajkumar.33-Dec-08 22:33 

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.