Click here to Skip to main content
12,897,444 members (49,095 online)

Welcome to the Lounge

   

For discussing anything related to a software developer's life. Technical discussions are encouraged, but click here to ask your programming questions.

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
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 

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.170424.1 | Last Updated 30 Apr 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid