Click here to Skip to main content
14,980,146 members
Home / Discussions / Database
   

Database

 
GeneralRe: Create a trigger Pin
lionelcyril18-Aug-11 19:12
Memberlionelcyril18-Aug-11 19:12 
GeneralRe: Create a trigger Pin
Wendelius18-Aug-11 19:18
mveWendelius18-Aug-11 19:18 
AnswerRe: Create a trigger [modified] Pin
Shameel18-Aug-11 23:03
professionalShameel18-Aug-11 23:03 
QuestionSQL Query From Query Results Pin
Kyudos18-Aug-11 14:36
MemberKyudos18-Aug-11 14:36 
AnswerRe: SQL Query From Query Results Pin
Mycroft Holmes18-Aug-11 15:04
professionalMycroft Holmes18-Aug-11 15:04 
GeneralRe: SQL Query From Query Results Pin
Kyudos18-Aug-11 15:22
MemberKyudos18-Aug-11 15:22 
GeneralRe: SQL Query From Query Results Pin
Kyudos18-Aug-11 18:34
MemberKyudos18-Aug-11 18:34 
GeneralRe: SQL Query From Query Results Pin
Mycroft Holmes18-Aug-11 20:38
professionalMycroft Holmes18-Aug-11 20:38 
Sorry I'm not get email notifications at the moment!

My eyes cross when I look at your query trying to figure out the joins. I have not used that style of join in over a decade.

You can use a sub select but it makes no real difference, why do you not want to used a table variable?
Never underestimate the power of human stupidity
RAH

GeneralRe: SQL Query From Query Results Pin
Kyudos18-Aug-11 22:07
MemberKyudos18-Aug-11 22:07 
GeneralRe: SQL Query From Query Results Pin
Mycroft Holmes18-Aug-11 22:19
professionalMycroft Holmes18-Aug-11 22:19 
Questionplz brack my licence Pin
saqibali211918-Aug-11 8:08
Membersaqibali211918-Aug-11 8:08 
AnswerRe: plz brack my licence Pin
Mycroft Holmes18-Aug-11 20:41
professionalMycroft Holmes18-Aug-11 20:41 
QuestionCannot start MSSQLSERVER Pin
Blikkies17-Aug-11 22:02
professionalBlikkies17-Aug-11 22:02 
AnswerRe: Cannot start MSSQLSERVER Pin
Mycroft Holmes17-Aug-11 23:02
professionalMycroft Holmes17-Aug-11 23:02 
GeneralRe: Cannot start MSSQLSERVER Pin
Blikkies18-Aug-11 3:59
professionalBlikkies18-Aug-11 3:59 
GeneralRe: Cannot start MSSQLSERVER Pin
jschell18-Aug-11 12:56
Memberjschell18-Aug-11 12:56 
AnswerRe: Cannot start MSSQLSERVER Pin
Corporal Agarn18-Aug-11 2:02
professionalCorporal Agarn18-Aug-11 2:02 
GeneralRe: Cannot start MSSQLSERVER Pin
Blikkies18-Aug-11 3:59
professionalBlikkies18-Aug-11 3:59 
AnswerRe: Cannot start MSSQLSERVER Pin
Wendelius18-Aug-11 6:26
mveWendelius18-Aug-11 6:26 
GeneralRe: Cannot start MSSQLSERVER Pin
Blikkies18-Aug-11 21:38
professionalBlikkies18-Aug-11 21:38 
QuestionOracle Collection Objects Pin
lionelcyril17-Aug-11 21:22
Memberlionelcyril17-Aug-11 21:22 
AnswerRe: Oracle Collection Objects Pin
Wendelius18-Aug-11 8:10
mveWendelius18-Aug-11 8:10 
GeneralRe: Oracle Collection Objects Pin
lionelcyril18-Aug-11 8:21
Memberlionelcyril18-Aug-11 8:21 
AnswerRe: Oracle Collection Objects Pin
Wendelius18-Aug-11 8:32
mveWendelius18-Aug-11 8:32 
GeneralRe: Oracle Collection Objects Pin
lionelcyril18-Aug-11 8:37
Memberlionelcyril18-Aug-11 8:37 

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.