Click here to Skip to main content
15,943,406 members
Home / Discussions / Database
   

Database

 
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 
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 
Common Table Expression

Yet another way to build more complex queries, Interesting

I had no idea I could express it like that, and would of never thought of looking for it in search.

I was close on the first couple of tries.

Thanks Jorgen!

I did read up on those articles you gave me, and have been designing my new stuff in such a manner.
Writing TSQL for reports can get more complex to produce the desired results.
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 
GeneralRe: how to convert an integer to days months years Pin
ahmad_yossef10-Mar-14 21:16
ahmad_yossef10-Mar-14 21:16 
AnswerRe: how to convert an integer to days months years Pin
Kornfeld Eliyahu Peter10-Mar-14 21:30
professionalKornfeld Eliyahu Peter10-Mar-14 21:30 

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.