Click here to Skip to main content
12,351,462 members (35,056 online)

Welcome to the Lounge

   

For lazing about and discussing anything in a software developer's life that takes your fancy except programming questions.

Technical discussions are encouraged, but click here to ask your programming question.

The Lounge is rated PG. If you're about to post something you wouldn't want your kid sister to read then don't post it. No flame wars, no abusive conduct, no programming questions and please don't post ads.
 
AnswerRe: walk the line Pin
HobbyProggy26-Feb-14 21:27
memberHobbyProggy26-Feb-14 21:27 
AnswerRe: walk the line Pin
Jörgen Andersson26-Feb-14 21:42
professionalJörgen Andersson26-Feb-14 21:42 
GeneralRe: walk the line Pin
V.26-Feb-14 21:47
professionalV.26-Feb-14 21:47 
GeneralRe: walk the line Pin
Jörgen Andersson26-Feb-14 22:12
professionalJörgen Andersson26-Feb-14 22:12 
GeneralRe: walk the line Pin
djj5527-Feb-14 0:38
professionaldjj5527-Feb-14 0:38 
AnswerRe: walk the line Pin
OriginalGriff26-Feb-14 21:55
protectorOriginalGriff26-Feb-14 21:55 
GeneralRe: walk the line Pin
djj5527-Feb-14 0:40
professionaldjj5527-Feb-14 0:40 
GeneralRe: walk the line Pin
OriginalGriff27-Feb-14 0:49
protectorOriginalGriff27-Feb-14 0:49 
AnswerRe: walk the line Pin
kArViD0tnEt26-Feb-14 22:03
professionalkArViD0tnEt26-Feb-14 22:03 
AnswerRe: walk the line Pin
Rage26-Feb-14 22:56
professionalRage26-Feb-14 22:56 
AnswerRe: walk the line Pin
chriselst26-Feb-14 23:06
professionalchriselst26-Feb-14 23:06 
AnswerRe: walk the line Pin
Ennis Ray Lynch, Jr.27-Feb-14 3:08
memberEnnis Ray Lynch, Jr.27-Feb-14 3:08 
AnswerRe: walk the line Pin
GenJerDan27-Feb-14 3:31
memberGenJerDan27-Feb-14 3:31 
GeneralMy most advanced SQL so far! Pin
Super Lloyd26-Feb-14 19:00
memberSuper Lloyd26-Feb-14 19:00 
Yeah I just finished debugging and writing my most complicated SQL script ever!

Though is only 300 lines long it has:
- create user defined table type
- used it in the stored proc defined below as argument
- use WHILE with BREAK and CONTINUE
- use IF
- create @Memory Tables
- use CTE
- use UNION
- use CASE in select, where and having
- use inner and outer join
- use group by, having, sum,


Yeah!
It's for an advanced dynamic user search (arbitrary number of arbitrary criteria and or/and condition on an arbitrary complicated tree of joined data table) (arbitrary here means user defined!)
My programming get away... The Blog...
DirectX for WinRT/C# since 2013!
Taking over the world since 1371!

GeneralRe: My most advanced SQL so far! Pin
ravikhoda26-Feb-14 19:09
professionalravikhoda26-Feb-14 19:09 
GeneralRe: My most advanced SQL so far! Pin
Super Lloyd26-Feb-14 19:55
memberSuper Lloyd26-Feb-14 19:55 
GeneralRe: My most advanced SQL so far! Pin
JimmyRopes26-Feb-14 20:02
memberJimmyRopes26-Feb-14 20:02 
GeneralRe: My most advanced SQL so far! Pin
Jörgen Andersson26-Feb-14 20:38
professionalJörgen Andersson26-Feb-14 20:38 
GeneralRe: My most advanced SQL so far! Pin
Super Lloyd26-Feb-14 21:32
memberSuper Lloyd26-Feb-14 21:32 
GeneralRe: My most advanced SQL so far! Pin
JimmyRopes26-Feb-14 21:35
memberJimmyRopes26-Feb-14 21:35 
GeneralRe: My most advanced SQL so far! Pin
Super Lloyd26-Feb-14 22:53
memberSuper Lloyd26-Feb-14 22:53 
GeneralRe: My most advanced SQL so far! Pin
JimmyRopes27-Feb-14 2:39
memberJimmyRopes27-Feb-14 2:39 
GeneralRe: My most advanced SQL so far! Pin
Super Lloyd26-Feb-14 22:54
memberSuper Lloyd26-Feb-14 22:54 
GeneralRe: My most advanced SQL so far! Pin
JimmyRopes27-Feb-14 2:41
memberJimmyRopes27-Feb-14 2:41 
GeneralRe: My most advanced SQL so far! Pin
DaveAuld26-Feb-14 23:01
protectorDaveAuld26-Feb-14 23:01 
GeneralRe: My most advanced SQL so far! Pin
Super Lloyd26-Feb-14 23:08
memberSuper Lloyd26-Feb-14 23:08 
GeneralRe: My most advanced SQL so far! Pin
kArViD0tnEt26-Feb-14 20:23
professionalkArViD0tnEt26-Feb-14 20:23 
GeneralRe: My most advanced SQL so far! Pin
devenv.exe26-Feb-14 20:34
memberdevenv.exe26-Feb-14 20:34 
GeneralRe: My most advanced SQL so far! Pin
Mohammad M. Mohammad26-Feb-14 20:45
memberMohammad M. Mohammad26-Feb-14 20:45 
GeneralRe: My most advanced SQL so far! Pin
Super Lloyd26-Feb-14 21:33
memberSuper Lloyd26-Feb-14 21:33 
GeneralRe: My most advanced SQL so far! Pin
Mohamad M. Mohamad26-Feb-14 21:44
memberMohamad M. Mohamad26-Feb-14 21:44 
GeneralRe: My most advanced SQL so far! Pin
Super Lloyd26-Feb-14 22:55
memberSuper Lloyd26-Feb-14 22:55 
GeneralRe: My most advanced SQL so far! Pin
Super Lloyd26-Feb-14 23:06
memberSuper Lloyd26-Feb-14 23:06 
GeneralRe: My most advanced SQL so far! Pin
Mohamad M. Mohamad26-Feb-14 23:30
memberMohamad M. Mohamad26-Feb-14 23:30 
GeneralRe: My most advanced SQL so far! Pin
Rage26-Feb-14 21:44
professionalRage26-Feb-14 21:44 
GeneralRe: My most advanced SQL so far! Pin
Super Lloyd27-Feb-14 12:46
memberSuper Lloyd27-Feb-14 12:46 
GeneralRe: My most advanced SQL so far! Pin
V.26-Feb-14 20:47
professionalV.26-Feb-14 20:47 
GeneralRe: My most advanced SQL so far! Pin
Super Lloyd26-Feb-14 21:30
memberSuper Lloyd26-Feb-14 21:30 
GeneralRe: My most advanced SQL so far! Pin
Rage26-Feb-14 21:46
professionalRage26-Feb-14 21:46 
GeneralRe: My most advanced SQL so far! Pin
Super Lloyd26-Feb-14 23:04
memberSuper Lloyd26-Feb-14 23:04 
GeneralRe: My most advanced SQL so far! Pin
Bassam Abdul-Baki27-Feb-14 0:35
professionalBassam Abdul-Baki27-Feb-14 0:35 
GeneralRe: My most advanced SQL so far! Pin
djj5527-Feb-14 0:46
professionaldjj5527-Feb-14 0:46 
GeneralA life lesson Pin
Ennis Ray Lynch, Jr.27-Feb-14 3:17
memberEnnis Ray Lynch, Jr.27-Feb-14 3:17 
GeneralRe: A life lesson Pin
Super Lloyd27-Feb-14 4:21
memberSuper Lloyd27-Feb-14 4:21 
QuestionFree private repositories Pin
Oshtri Deka26-Feb-14 17:41
memberOshtri Deka26-Feb-14 17:41 
AnswerRe: Free private repositories Pin
Paul Conrad26-Feb-14 18:42
memberPaul Conrad26-Feb-14 18:42 
AnswerRe: Free private repositories Pin
JimmyRopes26-Feb-14 19:50
memberJimmyRopes26-Feb-14 19:50 
AnswerRe: Free private repositories Pin
_Maxxx_26-Feb-14 23:58
professional_Maxxx_26-Feb-14 23:58 
GeneralRe: Free private repositories Pin
Oshtri Deka27-Feb-14 2:18
memberOshtri Deka27-Feb-14 2:18 
GeneralFor the enjoyment of the VMS fans Pin
PIEBALDconsult26-Feb-14 17:06
memberPIEBALDconsult26-Feb-14 17:06 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.160621.1 | Last Updated 27 Jun 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid