Viewing 15 posts - 256 through 270 (of 4,080 total)
Please do post the results when you find your answer. I'm curious myself.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2016 at 6:36 am
Personally I prefer an error, but perhaps things are handled easier in some cases if a NULL is returned.
Which NULLIF([somecolumn],0) handles perfectly, if that is the desired behavior.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2016 at 6:26 am
In the absence of seeing your view, I can only see one thing that jumps out at me. You are starting your second query with FROM (SELECT DISTINCT...
Some...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 7, 2016 at 8:47 pm
Re-reading.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 7, 2016 at 8:30 pm
Could you please clarify exactly which rowIDs you want to flag for Hold?
I'm seeing them in this order:
rowid
1
5
2
3
4
7
6
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 7, 2016 at 4:15 pm
Did he say it looks clunky or it runs clunky?
I think your DBA is being really picky unless you have company standards for formatting, but.
SELECT d.WORK_TYPE AS...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 7, 2016 at 6:40 am
The tables and data you included look like result sets based on each of the elements. To figure out permutations don't you need to start with the the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 6, 2016 at 8:33 pm
I see your issue now. I'm afraid I don't have any brilliant insights. I hope the code you are generating above runs satisfactorily for...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 6, 2016 at 4:44 pm
You are right, Drew. I missed that in my cutting and pasting. Thank you for setting it straight. 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 6, 2016 at 1:32 pm
Nah.... he's gotten lazy. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 6, 2016 at 9:54 am
You're quite welcome, but once again I urge you to read the article about how to best post questions. We all would have gotten to the correct answer...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 6, 2016 at 9:53 am
Goodbye, Gregory. I'm done feeding trolls for a lifetime.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 6, 2016 at 6:32 am
Gregory, you are arguing semantics based on *your* definition of null. We are telling you how SQL works. Further argument is pointless here because they are...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 6, 2016 at 6:29 am
Spin, would you expect the same results from this data as the results you displayed earlier?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 6, 2016 at 6:24 am
You're welcome, Joe.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 6, 2016 at 6:22 am
Viewing 15 posts - 256 through 270 (of 4,080 total)