Click here to Skip to main content
15,179,830 members
Home / Discussions / Database
   

Database

 
AnswerRe: + operaotor for outer joins in mysql. Pin
Jörgen Andersson3-Jun-14 22:16
professionalJörgen Andersson3-Jun-14 22:16 
SuggestionData Mining Structure not Available in SSAS Tabular Model Pin
FLouis382-Jun-14 7:14
professionalFLouis382-Jun-14 7:14 
QuestionReady to give up on MySQL - is PostgreSQL better? Pin
Wombaticus1-Jun-14 23:09
MemberWombaticus1-Jun-14 23:09 
AnswerRe: Ready to give up on MySQL - is PostgreSQL better? Pin
Jörgen Andersson1-Jun-14 23:37
professionalJörgen Andersson1-Jun-14 23:37 
GeneralRe: Ready to give up on MySQL - is PostgreSQL better? Pin
Wombaticus1-Jun-14 23:43
MemberWombaticus1-Jun-14 23:43 
GeneralRe: Ready to give up on MySQL - is PostgreSQL better? Pin
Jörgen Andersson2-Jun-14 0:08
professionalJörgen Andersson2-Jun-14 0:08 
QuestionA query with lot of inner queries Pin
indian14329-May-14 13:41
Memberindian14329-May-14 13:41 
AnswerRe: A query with lot of inner queries Pin
Mycroft Holmes29-May-14 14:02
professionalMycroft Holmes29-May-14 14:02 
What a bloody awful construct - I doubt there is any tool to change the structure other than manually coding it.

As you will know the data structure you should be able to identify the joins in there and move them to a more supportable format.

SQL
INNER JOIN TableName as Alias ON A.Field = B.field


OR

Move the entire database to SQL Server where there are tools to help build and tune the query.
Never underestimate the power of human stupidity
RAH

GeneralRe: A query with lot of inner queries Pin
indian14329-May-14 14:09
Memberindian14329-May-14 14:09 
GeneralRe: A query with lot of inner queries Pin
Mycroft Holmes29-May-14 15:08
professionalMycroft Holmes29-May-14 15:08 
AnswerRe: A query with lot of inner queries Pin
Jörgen Andersson29-May-14 23:20
professionalJörgen Andersson29-May-14 23:20 
GeneralRe: A query with lot of inner queries Pin
Mycroft Holmes30-May-14 2:50
professionalMycroft Holmes30-May-14 2:50 
GeneralRe: A query with lot of inner queries Pin
Jörgen Andersson30-May-14 4:15
professionalJörgen Andersson30-May-14 4:15 
GeneralRe: A query with lot of inner queries Pin
indian14330-May-14 10:08
Memberindian14330-May-14 10:08 
GeneralRe: A query with lot of inner queries Pin
Jörgen Andersson30-May-14 10:24
professionalJörgen Andersson30-May-14 10:24 
GeneralRe: A query with lot of inner queries Pin
indian14330-May-14 10:05
Memberindian14330-May-14 10:05 
GeneralRe: A query with lot of inner queries Pin
Mycroft Holmes30-May-14 13:46
professionalMycroft Holmes30-May-14 13:46 
QuestionProblem with tempdb - MSSQL Pin
Milan K SK28-May-14 5:32
MemberMilan K SK28-May-14 5:32 
AnswerRe: Problem with tempdb - MSSQL Pin
Kornfeld Eliyahu Peter28-May-14 7:39
professionalKornfeld Eliyahu Peter28-May-14 7:39 
QuestionSQL Server 2012 Agent Job & stored procedure issue URGENT Pin
Seuss27-May-14 12:10
MemberSeuss27-May-14 12:10 
AnswerRe: SQL Server 2012 Agent Job & stored procedure issue URGENT Pin
Mycroft Holmes27-May-14 13:45
professionalMycroft Holmes27-May-14 13:45 
GeneralRe: SQL Server 2012 Agent Job & stored procedure issue URGENT Pin
Seuss27-May-14 21:10
MemberSeuss27-May-14 21:10 
GeneralRe: SQL Server 2012 Agent Job & stored procedure issue URGENT Pin
Mycroft Holmes27-May-14 21:22
professionalMycroft Holmes27-May-14 21:22 
GeneralRe: SQL Server 2012 Agent Job & stored procedure issue URGENT Pin
Seuss27-May-14 23:14
MemberSeuss27-May-14 23:14 
GeneralRe: SQL Server 2012 Agent Job & stored procedure issue URGENT Pin
NitinDhapte16-Jun-14 2:55
MemberNitinDhapte16-Jun-14 2:55 

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.