Click here to Skip to main content
15,947,612 members
Home / Discussions / Database
   

Database

 
QuestionHo to avoid Not In & In clause in my query Pin
member002611-Mar-14 0:43
member002611-Mar-14 0:43 
AnswerRe: Ho to avoid Not In & In clause in my query Pin
Bernhard Hiller11-Mar-14 1:04
Bernhard Hiller11-Mar-14 1:04 
GeneralRe: Ho to avoid Not In & In clause in my query Pin
member002611-Mar-14 18:08
member002611-Mar-14 18:08 
AnswerRe: Ho to avoid Not In & In clause in my query Pin
thatraja11-Mar-14 2:07
professionalthatraja11-Mar-14 2:07 
AnswerRe: Ho to avoid Not In & In clause in my query Pin
GuyThiebaut11-Mar-14 3:54
professionalGuyThiebaut11-Mar-14 3:54 
QuestionAdding Sales Totals from multiple tables Pin
jkirkerx9-Mar-14 10:54
professionaljkirkerx9-Mar-14 10:54 
AnswerRe: Adding Sales Totals from multiple tables Pin
Mycroft Holmes9-Mar-14 14:16
professionalMycroft Holmes9-Mar-14 14:16 
GeneralRe: Adding Sales Totals from multiple tables Pin
jkirkerx9-Mar-14 17:44
professionaljkirkerx9-Mar-14 17:44 
Thanks!

I understand the example, but I still get the ")" error in which I don't understand. There's only 3 of them.

The common ID and the GroupBy with the inner join is going to take me some time to experiment with.
I'm not really sure where to start with that one.
AnswerRe: Adding Sales Totals from multiple tables Pin
Jörgen Andersson9-Mar-14 22:01
professionalJörgen Andersson9-Mar-14 22:01 
GeneralRe: Adding Sales Totals from multiple tables Pin
jkirkerx10-Mar-14 6:26
professionaljkirkerx10-Mar-14 6:26 
GeneralRe: Adding Sales Totals from multiple tables Pin
Jörgen Andersson10-Mar-14 8:35
professionalJörgen Andersson10-Mar-14 8:35 
QuestionHow to prevent or allow a insert trigger ? Pin
ngoloi9-Mar-14 6:15
ngoloi9-Mar-14 6:15 
AnswerRe: How to prevent or allow a insert trigger ? Pin
Mycroft Holmes9-Mar-14 13:09
professionalMycroft Holmes9-Mar-14 13:09 
GeneralRe: How to prevent or allow a insert trigger ? Pin
ngoloi9-Mar-14 18:02
ngoloi9-Mar-14 18:02 
AnswerRe: How to prevent or allow a insert trigger ? Pin
GuyThiebaut9-Mar-14 22:37
professionalGuyThiebaut9-Mar-14 22:37 
GeneralRe: How to prevent or allow a insert trigger ? Pin
ngoloi10-Mar-14 4:28
ngoloi10-Mar-14 4:28 
GeneralRe: How to prevent or allow a insert trigger ? Pin
GuyThiebaut10-Mar-14 4:52
professionalGuyThiebaut10-Mar-14 4:52 
QuestionSql Server Express: Testing sql-commands Pin
Frygreen9-Mar-14 3:03
Frygreen9-Mar-14 3:03 
AnswerRe: Sql Server Express: Testing sql-commands Pin
Richard MacCutchan9-Mar-14 3:33
mveRichard MacCutchan9-Mar-14 3:33 
AnswerRe: Sql Server Express: Testing sql-commands Pin
Jörgen Andersson9-Mar-14 7:42
professionalJörgen Andersson9-Mar-14 7:42 
AnswerRe: Sql Server Express: Testing sql-commands Pin
Mycroft Holmes9-Mar-14 13:05
professionalMycroft Holmes9-Mar-14 13:05 
AnswerRe: Sql Server Express: Testing sql-commands Pin
Richard Deeming10-Mar-14 2:49
mveRichard Deeming10-Mar-14 2:49 
GeneralRe: Sql Server Express: Testing sql-commands Pin
Frygreen10-Mar-14 7:40
Frygreen10-Mar-14 7:40 
Questionhow to convert an integer to days months years Pin
ahmad_yossef9-Mar-14 2:53
ahmad_yossef9-Mar-14 2:53 
GeneralRe: how to convert an integer to days months years Pin
Kornfeld Eliyahu Peter9-Mar-14 3:25
professionalKornfeld Eliyahu Peter9-Mar-14 3:25 

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.