« first day (457 days earlier)      last day (3563 days later) » 

12:07 PM
0
Q: Is a bad approach for a problem a good reason to close that question?

PimgdSee Accelerate OpenGL 2D on Python3 and Finding Primes in Java. These questions have one thing in common: They are about performance. They worded their question in a manner as "it reaches speed X, but I'd wish it would reach speed Y". For the first linked question, there are (at the moment of w...

self-answered but I'm not sure of my answer
I was writing my answer into my question and realized that would hamper discussion, so that's why I did it
Also it kept getting harder and harder to have a question with my answer in the question text and when I removed my answer from the question text it became clear again
 
I think your answer is the correct one.
 
can you explain to me why
Because my mind is trying to make a point and I have trouble understanding myself
editted question and answer a bit
 
@Pimgd We review code, not necessarily algorithms. Most algorithms don't entirely become obsolete because many of them are still appropriate in specific circumstances that apply to real-world situations. Also, many courses study historical algorithms and so CS students may be directed to write code using a specific algorithm.
 
!
scribble scribble
We review code, not necessarily solutions.
Does that mean the inverse then?
Is suggesting a completely different solution a bad answer?
It most certainly is a source of bad answers
With code rewrites without explanation
 
@Pimgd you're right, it does make for bad answers. when i'm tempted to answer with a rewrite, i try to make sure i explain the why, not just the how
 
12:19 PM
1
Q: Is a bad approach for a problem a good reason to close a question?

PimgdSee Accelerate OpenGL 2D on Python3 and Finding Primes in Java. These questions have one thing in common: They are about performance. They worded their question in a manner as "it reaches speed X, but I'd wish it would reach speed Y". For the first linked question, there are (at the moment of w...

 
like... let's follow your approach to its logical conclusion, and see why it's inefficient. now let's try to think of a more efficient way
 
Well actually in regards to the primes question
It tried to divide the possible prime by all numbers up to half -1 the value of the possible prime
or, well, half rounded up -1
And then people came with a ton of suggestions and it boiled down to "try with all primes that are at or below the square root of the possible prime"
which seems quite fast to me
So it's even possible that my answer could be invalidated by just proper optimization of the algorithm in question
I think I'll ask the other question beside it, they complement each other but if I stick it in the current one they'll complicate each other
 
@Pimgd You weren't wrong to suggest a sieve instead, but I do think you could have addressed the things you just pointed out.
 
I didn't know them until days later
 
Fair enough.
 
12:27 PM
or, uh well
today
 
Lol. Most people start with the naive algoritm and discover the sieve later. Not @Pimgd. That's awesome buddy.
 
I like reading things.
 
So do I. That's how I end up burning so many votes.
 
Checking a project I made a year ago... And it hurts.
2
 
12:44 PM
pffft finally, back 5 min free
 
morning all
 
morning @bazola
 
Aaand the inverted question
0
Q: Is solely suggesting another solution a bad answer?

PimgdRelated to Is a bad approach for a problem a good reason to close a question?, this question is about the opposite instead: Is solely suggesting another solution a bad answer? We've been over this already, partially, in the question Short answers and code-only answers, but I wish to point out on...

 
0
Q: Is solely suggesting another solution a bad answer?

PimgdRelated to Is a bad approach for a problem a good reason to close a question?, this question is about the opposite instead: Is solely suggesting another solution a bad answer? We've been over this already, partially, in the question Short answers and code-only answers, but I wish to point out on...

 
0
Q: Simple wildcard pattern matcher in java

Bhathiya-JaDogg-PereraI have built a simple wild card pattern matcher algorithm, I am concerned where it can be improved. Main concern is algorithm. Any other improvements are welcome too. What it should does : match * -> one or more of any character match ? -> any single character similar to the f...

 
1:00 PM
@Pimgd already answered..
0
A: Is solely suggesting another solution a bad answer?

Vogel612I will answer this with our 6 magic questions, especially question no. 6: Do I want feedback about any or all facets of the code? To me what definitely belongs into "facets" of code is the approach to the problem. This includes algorithm choice, architectural structure, class naming and des...

bottom line: you worry too much ;)
 
Eh, somewhere down the line I'm struggling with a definition problem, but my brain is taking the day off so I can't tell you what it is
 
@Pimgd you seem to want to keep code and solution separated...
but that's not the case.
if you review the code, you automatically can review the solution behind it.
 
Well I did come with one idea
which is to write crap code that works
then pull it through CR
and yay nice code
 
@Pimgd don't you dare ; )
 
It'd be a whole new level of "gimme teh codez"
 
1:07 PM
@CaptainObvious Worst. Naming. Ever.
 
Basically on the level of "I made a go-kart, can I copy your race car now"
 
@Pimgd Don't understand your comment...
 
"If the question asks specifically for feedback on one facet only, it's a bad question, because it doesn't want a review on all aspects."
 
Where is that self-contradictory?
 
"To be on-topic the answer must be "yes" to all questions: (...) Do I want feedback about any (or all) facets of the code?"
 
1:08 PM
@Pimgd well there is a wide spread of programmer skill in the questions on this site, so I'm sure there are many people who post the best working code they can, but others would still consider it "crap" code
 
... what you're saying is that it's a bad, on-topic question
that feels contradictory to me
 
@Pimgd right...
no...
 
No?
 
how would that be contradictory??
 
cause bad questions are off-topic?
 
1:09 PM
You ask "I got code, but my algo seems to be crap"
lol no...
you mix things up. even good questions can be off-topic.
the quality of a question is not decided by it's fit to the scope
 
Ah yeah
 
It's depending on whether the question is easy to understand and illustrates the "problem"
 
0
Q: How to enable Numeric CAPTCHA in my windows application

Sujith KarivelilNow a days many sites introduces CAPTCHA (Completely Automated Public Turing test to tell Computers and Humans Apart)for securing their sites. I wish to introduce the technique in windows forms, as expression evaluation CAPTCHA. Algorithm: Two randomly generated integers are loaded into tw...

 
@bazola that's true, and it's why I keep thinking to myself "the points I am making are wrong because I did it like that one day and surely posting that on here couldn't be a bad question"
It might have been off-topic though
Ooh it reached +50
sweet
 
I would go one step further myself and say that it is actually unfortunate that we require people to post working code, but it is a necessary failsafe to protect against all the "gimme teh codez" questions we would see otherwise. Non working code would actually be informative to review for a great many people, and in a perfect world there would be questions about non working code that would make great questions and have great, informative answers
 
1:17 PM
@Pimgd suggestion: get a coffee!
I don't understand your comment yet again.
 
Logic:
- All facets of code are subject for review
- Answer that is about one or more facets is on-topic
 
fixed my bot on that king of the hill question on Code Golf
1
A: The Rock, Paper, Scissors, Lizard, Spock Tournament of Epicness

MalachiDice Throw Bot, C# Truly Random using System; using Microsoft.CSharp; using Microsoft.Win32.SafeHandles; using System.Collections.Generic; using System.Linq; public static void Main (string[] args) { var computerPlay = GetRandomOption(gameGestures); IList<Gesture> gameGestures = GetGes...

 
- Answer that is correct about changes/suggestions on one or more facets is good answer
- If answer about only the solution is correct and seen as good answer...
 
@bazola The problem IMHO is not even "gimme teh codez" questions. The problem is that Stack Overflow primary on-topic question are "My code is not working how can I fix it". If we focus on fixing people code, we would be a Stack Overflow 0.5.
 
1:20 PM
then is the solution also part of the code to be reviewed?
(Also I don't like coffee)
Run Pim run you're gonna get murdered now for blasphemy
 
Do you like tea ?
 
yeah tea is nice
@bazola what kind of question do you think would be a good question, even if it didn't have working code?
 
this looks like an upcoming coding challenge to me....
in The Nineteenth Byte, 2 mins ago, by Trimsty
Langton's ant is a two-dimensional Turing machine with a very simple set of rules but complicated emergent behavior. It was invented by Chris Langton in 1986 and runs on a square lattice of black and white cells. The universality of Langton's ant was proven in 2000. The idea has been generalized in several different ways, such as turmites which add more colors and more states. == Rules == Squares on a plane are colored variously either black or white. We arbitrarily identify one square as the "ant". The ant can travel in any of the four cardinal directions at each step it takes. The ant moves...
 
One of the good answers I envision for questions with broken code is slapping someone with mathematical proof that his solution is NEVER going to work
 
@nhgrif posted something about that on the meta that would be a better answer than I could give, let me see if I can find it
 
1:23 PM
the accompanying question would be something like "how do I handle all these edge cases nicely, currently adding support for each edge case is like playing whack-a-mole in my code"
 
@Pimgd blasphemer!
 
Monking!
 
0
Q: Python using a base class but defining a property

simonzackI have designed a python tree node base class, so all tree nodes I implement can inherit from this. However, due to the laziness inherent in a lot of trees, I would like some fields to be properties (using the @property decorator) instead. But doing so, the base class will raise AttributeError w...

 
1:41 PM
Monking!
 
monking @Phrancis
 
0
Q: Efficient way to extract the first row in a Group By group

simoneLI have a large Sql Server view with this schema: [archive_ID] (int, not null) [archive_date] (datetime, not null) [archdata_path_ID] (varchar(50), not null) [archdata_value] (int not null) I need to group the records by the Date, and I need to extract just the first record for each group. Th...

 
@Jamal, can I post on a protected question when I haven't recieved any Rep from the site if I am a trusted user elsewhere in the SE?
 
@Malachi no
 
No, you must earn 10 rep on that site. The association bonus doesn't count.
 
 
55
A: What is a “protected” question?

waiwai933What does it mean for a question to be protected? Protected questions have the additional restriction that new users are not permitted to answer the question. Unlike locked questions, they can still be edited, commented on, and voted on. You can even vote to close them. Why are some questions...

 
"What are protected questions? (...) Note that one needs to earn 10 rep on the site to be able to answer a protected question. The association bonus does not count."
 
2:07 PM
> For practicality, the instant is stored with some constraints. The measurable time-line is restricted to the number of seconds that can be held in a long. This is greater than the current estimated age of the universe.
Well... ok then
 
2:19 PM
Busy day on meta .... nice.
Monking all!
 
Monking @rolfl!
 
Monking @rolfl
 
@Phrancis
 
Yo
 
I hate DB Designers sometimes...
 
2:20 PM
you may congratulate me, I am now officially rolling back two months worth of commits....
3
 
@Malachi that makes two of us ;)
 
@Vogel612 roll roll roll roll
 
@Phrancis I have text columns holding dates and dollar amounts. I want the newest record, how do I do that?
 
@Vogel612 They see me rollin', they hatin'.
2
 
Text as in, varchar?
 
2:22 PM
@Malachi What's the format of the date?
 
I would think SELECT MAX(Date_Column), Dollar_Column FROM MyTable
 
what the heck is wrong with you, git...
git reset --hard commit-hash
but no, of course it won't work..
 
@Phrancis no group by!
 
@Phrancis that is what I tried....lol
 
@Malachi That single statement contains so many broken concepts
 
2:25 PM
@rolfl lol, that's how I feel when trying to deal with this part of the DB
 
Like, WTF, you have text columns containing Dates and Dollar amounts....
No, you do not...
 
Wouldn't you have to use a subselect to get the most recent date, which you could then use to select the row that you want?
 
you have text columns, containing text.
 
Hmm
 
I have a text columns containing information that should be a DATETIME and a DECIMAL
 
2:26 PM
Yes, so you have a broken schema, then wonder why the queries are hard.
 
@rolfl 3rd party application and DB
 
Get a 4th party
 
nothing I could have ever done about it....
 
SELECT Date_Column, Dollar_Amount ORDER BY Date_Column DESC LIMIT 1
 
If the date text is all most significant field first, then you can use regular ordering, otherwise you have to parse it.
 
2:27 PM
@Malachi `
 
07/26/2001 09:00 AM is the date format
 
@rolfl SELECT INTO /dev/null
2
 
You'll have to parse it. That's going to get ugly.
 
icing on the cake today....
 
it was ugly to start with, this is actually making it nicer....
 
2:28 PM
I would rather be somewhere near Strugis riding my motorcycle than doing this SQL crap on a crappy table
this Table is horrible.
it holds information for fields of the application, it's a horrible design.
 
@Malachi Does you DBMS have a date parsing function?
 
@Malachi?
2
 
@Donald.McLean I tried Convert, but it didn't like that, but I assume you mean something else
 
What is the database? SQL Server?
 
0
Q: using array.concat, but running into a type mismatch problem

Adam O'NeilI'm trying to use the array Concat method to combine a literal, hard-coded array of a type called SearchDef.Column with an array returned by a static function on my class. The static function also returns SearchDef.Column[]. This is the basis for an end user query tool which combines a number of ...

 
2:30 PM
@rolfl the column is a Text data type because of the different information that column can hold.
SQL SERVER
this Query would not be possible if it weren't for CTE's....lol
calling the same query twice to pull two different pieces of information....
 
Ah, so you have a Text column taht sometimes contains dates,
 
@rolfl and numbers
 
@Malachi wait... the same column can hold multiple formats of information??
 
@CaptainObvious VTC
 
@Phrancis yes
FACEPALM
 
2:32 PM
That's terrible
 
I see a picture
 
That's my cue to say.... Breakfast time!
 
lol
 
Ah, this is why I was done so fast with this assignment, I missed half of it.
2
 
2:33 PM
I am going to try and convert to Varchar first and then try some fun stuff. good thing the query doesn't take very long.
@skiwi bummer, I hate when that happens
 
@skiwi Did you figure that out before, or after you handed it in?
 
@Malachi maybe you could try a hack like SELECT Date_Column, Dollar_Amount FROM Table WHERE Date_Column LIKE '%%/%%/%%%%'
 
@rolfl Before, I was testing it by adding in documents and seeing all kinds of things change... Except, that nothing happened.
Luckily I've already done this before so can reuse a lot :)
 
so I flagged this answer because it was a duplicate answer and should have been done away with on SO, and I was Declined, can a Moderator explain why I might have been wrong to flag so I don't do this again?
0
A: Android SDK Manager Not Installing Components

JayPOpening the application on administrator mode helps. Just right click the icon and click "run as administrator"

@Phrancis I want the newest records though for each Case, I am returning several cases with unique identifiers and several records per case
 
@Malachi agree with you. Sometimes mods at SO are just being dicks...
4
 
2:43 PM
@Malachi Reading through the Transact-SQL docs, it looks like CONVERT would be the correct call. What did your query look like, and what was the result?
 
@Malachi I plugged a few values into Access and ran this: select id, max(mydate) from testtable group by id; and seems to return the expected results
 
@Vogel612 But, most of the time they are not.
 
To me it looks more like, some of them are just fed up with the piling flag-queue.
 
In this case, it's not nice for Malachi to be questioning SO modes on Code Review chat when the documented procedure would be for @Malachi to post a question to SO Meta, and ask why....
 
@rolfl point taken..
 
2:48 PM
Most likely the answer will be: Why does a mod need to deal with that.
 
@Vogel612 Well I would disagree, being an SO moderator is hard and sometime a flag which is clear to us could not look that clear to them. They do a lot of work so don't be that harsh to them.
 
that is something the community should deal with using down-votes and delete votes.
that is what they are for.
 
@rolfl in theory that sounds so nice..
 
If mods get flagged every time there is a duplicate answer on SO you can imagine that they will be very busy
5
 
And I would add : Never attribute to malice that which is adequately explained by stupidity. (I would consider stupidity as a simple error or something else)
 
2:58 PM
I still remember:
> this question would be a nice fit for CodeReview imo.. – Vogel612 May 19 at 14:37 declined - We dont' migrate to beta sites; best bet is to ask the user to ask it there
 
1
Q: Canvas loading animation

Ben FortuneSo this is kind of a follow-on from here. I've been trying to copy the following GIF animation using a canvas. I have re-factored the code following Stuart's pointers and wanted to know if I was doing what I should be. jsbin /*Start Canvas*/ var Canvas = function(canvas) { this.canvas = ...

 
-1
A: Moderator Selection Techniques

SF.1 - The absolutely most common moderator selection technique is "Good pals/lovers/drink buddies of the site owner." Their skills at moderation being entirely irrelevant and often abysmally bad, often the moderators outnumbering users, fighting between each other and being dismissed after a disagr...

that sucks, he's not even a Mod on the Network....
 
how the heck are there 160 users in the Ban Hammer??
nevermind...
157 people chatting..
 
lol
 
0
Q: Check if URL contains different strings

MasonThe code it self is pretty self explanatory, however i do not think it is very efficient at all. Is there a better way to do this? Its basically so i can track spam sites and save the sites into my honeypot db. <?php $site = $_GET['url']; $con=mysqli_connect("localhost","_","","_"); // Check co...

 
3:05 PM
people chatting != people in the ban hammer
 
@CaptainObvious looks like that one has my name on it?
 
@Phrancis now I have the issue of Ordering by DATETIME DESC
 
@Jamal Do a mod or anyone has deleted my comment on the javascript question ?
 
WHich question?
 
3
Q: Canvas loading animation - follow-up

Ben FortuneThis is kind of a follow-on from here: Canvas animation I've been trying to copy the following GIF animation using a canvas. I have re-factored the code following Stuart's pointers and wanted to know if I was doing what I should be. jsbin /*Start Canvas*/ var Canvas = function(canvas) { ...

 
3:20 PM
@Donald.McLean CONVERT(DATETIME,(CONVERT(nVARCHAR,DCV.FieldValue))) is what I needed, I must not have tried that one yet.....
@Marc-Andre did you try refreshing the page?
 
Well yeah and I did check my activity page
 
@Marc - Jamal deleted the comment, it was chatty, and not asking for clarification on the questions.... at least, those are reasons I would delete that comment.
also.
all code posted to SE Sites are psoted with the Creative COmmons share-alike with attribution license, so the answer is ... yes
 
That was what I thought, I would have deleted my comment after receiving an answer but well not a big deal.
 
@Marc-Andre I deleted it since the OP had already posted that JS link.
 
And that too.
It is a cool animation
2
 
3:23 PM
@rolfl Well I agree with that part but sometime people are not aware of that "legal" fact. And if I could use his code as another license it could have been easier in some case.
 
That is true, and I can understand your reasoning, but, the right place for that would not be in comments on the question, but in chat, or something.... comments are not for conversations.
 
Well that's fine with me ! Thanks for the rapid answer! :D
 
Yet another -review today... I begin to question my intentions of writing good code...
 
@rofl SO mods need to deal with that because the only way for a large number of SO users to deal with duplicates is to flag them as dupes. The people with enough rep to mark dupes without a flag don't. They answer them.... SO is a wasteland.
 
@Malachi what is the issue?
 
3:28 PM
@Phrancis @Marc-Andre already got it figured out.
 
Ok cool
 
I think that my query is good enough for the Adhoc Report, now I just have to run the report and figure out if all the data is good or not, will probably take the rest of the day.....
 
Ouch
 
1
Q: Functional Programming style in F#

alundI'm normally a C# developer, but I've started to learn F# and I want to make sure I'm writing code in a functional way that suits the language. I've quickly pieced this together with my knowledge from reading Functional Programming for the Real World and various material from the Web. Please loo...

 
3:51 PM
check out this fun discussion

English Part 1

9 mins ago, 8 minutes total – 21 messages, 3 users, 1 star

Bookmarked 12 secs ago by Malachi

 
Am I wrong in thinking that this looks dirty? $con=mysqli_connect("localhost","_","","_");` or does it just look like it was edited to remove login information?
 
wat?
no you're definitely not
either way, TTQW, go home and weep into my pillow for the lost work...
Laters ;)
 
4:11 PM
So, I know that as soon as I mention a post in here, it will get more eyes on, but, I answered a python question last night, and it's not got any votes (neither up, nor down), and the answer is .... controversial. So, it may be a bad answer, or it may be good, but, I am not sure since there's no feedback .... thoughts?
 
Actually, I just smoked the PHP documentation and it does look like it was edited to remove user name, password and DB name
 
Can we get one more close vote on this?
-1
Q: Efficient way to extract the first row in a Group By group with Linq

simoneLI have a large Sql Server view with this schema: [archive_ID] (int, not null) [archive_date] (datetime, not null) [archdata_path_ID] (varchar(50), not null) [archdata_value] (int not null) I need to group the records by the Date, and I need to extract just the first record for each group. Th...

 
@rolfl have you used any version of SQL to store images as blobs or anything like that? Pros/cons?
 
I agree with you guys. Anyway I think I am misunderstood. Using the Group By is NOT a requirement, it was the only idea I have to improve the query.. The current one is working correctly, but in my opinion is difficult to maintain. It's not important which technique you suggest. — simoneL 16 mins ago
 
@ckuhn203 done
 
4:26 PM
@Phrancis - no, my DB work has always been in the financal industry (trading, insurance, accounting).
We have used CLOBS for a number of thins, mostly some .... serialized Java ddata, I think
 
CLOBS?
 
Character long objects
 
that sounds like fun
@ckuhn203 I have edited the question so that it sounds more on-topic and cast a reopen vote.
 
This feels dirty...
$result = mysqli_query($con,"INSERT INTO `rocket_newsites`.`payday` (`id`, `url`) VALUES (NULL, '$site');");
 
@Malachi I removed my downvote, but I still don't know if it's on topic.
 
4:38 PM
the user keeps asking about linq. we have stated that we will not write code for the user. (should post an "unless you donate to my paypal account" disclaimer)
3
 
@rolfl it has a mistake, I fixed it
 
@Phrancis, SSRS Date Formatting for just the Date and no time???
nevermind, i figured it out
in The Nineteenth Byte, 12 mins ago, by Rainbolt
What on earth is going on in here? Nobody said XKCD, so why all the stars?
I think that was me......
 
in The Nineteenth Byte, 13 mins ago, by Martin Büttner
I was afraid the "so many stars" one would get a star... I had to prevent that
 
0
Q: Tasks and WaitAll\WhenAll

kulaeffCould you help me to speed up/optimize this code: var keys = xRoot.Elements("key").Select(key => new { ID = int.Parse(key.Attribute("id").Value), VerificationCode = key.Attribute("verificationCode").Value }); var tasks = keys.Select(key => EveOnlineClient.GetAccountStatusAsync(key.ID, key.Verif...

 
@ckuhn203 starred it
=D
 
4:53 PM
0
Q: Prefered method

user2097159I'm wondering which of the following would be more appriate I believe them to be logically equivalent but am looking for opinions and input for column in config: colmap = config[column].split('-') if len(colmap) > 1: print str(colmap[1]) + str(colmap[0]) else print column or should...

I'm not quite sure if the OP is asking for a review. It kinda looks incomplete.
 
I was just looking at that one too.
 
hello
 
Hi @janos!
 
hi @Marc-Andre!
 
Hola @janos!
 
4:59 PM
0
Q: Prefered method

user2097159I'm wondering which of the following would be more appriate I believe them to be logically equivalent but am looking for opinions and input for column in config: colmap = config[column].split('-') if len(colmap) > 1: print str(colmap[1]) + str(colmap[0]) else print column or should...

 
hey @ckuhn203
 
@CaptainObvious I can't think of a better title until OP gives us some context.
 
Downvoted until it is clarified.
 
Hello folks. :)
 
@ckuhn203 lol
 
5:04 PM
hello @kleinfreund
 
Hey @janos
 
@Pimgd Thanks. Hmmm....
 
@Pimgd Bad questions aren't inherently off-topic--they're just bad.
4
 
That^
 
Off-topic questions aren't even inherently bad either--they're just bad for CR.
3
 
5:13 PM
I posted on Meta this time @rolfl meta.stackoverflow.com/q/267693/1214743
@Phrancis are CTE's considered Variables?
1
A: Efficient way to extract the first row in a Group By group

PenutReaper Okay, you firstly, in your CTE you bring back SELECT * even though you don't use most of the columns. That Select * can be removed and replaced with the actual columns you need. The CTE, while arguably helping readability a little is not very quick, I would recommend avoiding CTE's, and using s...

 
No, CTEs are not considered variables.
You can't reuse a CTE.
 
@nhgrif that is what I was thinking
 
But he's talking about a table variable, not a CTE.
Also, his answer isn't wrong...
 
@Malachi lol wat?
 
A CTE isn't slower than a subquery...
It's not faster either. Just more readable.
 
5:21 PM
@nhgrif it functions differently than a sub query
 
You know there's a difference between CTE, temp table, and table variable, right?
 
yeah, I usually have to look up the differences though.....
 
He didn't say anything wrong in his answer.
 
a CTE a table that only exists for one transaction or command, am I using the right word
 
It's not a table.
 
5:23 PM
it's a Table Expression
 
Yes.
 
I have seen where Temp tables are better than Table variables in some circumstances
 
And in others, the opposite.
A non-recursive CTE will perform almost identically to a subquery.
 
Temp Tables can be created and dropped, and can have a global scope, where as Table variables cannot
 
@rolfl hey rolfl, long time no see :D I little bird comes with a message for you.
Alex M.: could you please tell rolf I'm sorry for my behavior
Alex M.: and if he could kindly unban me?
 
5:25 PM
So again, the only real difference between CTE and subquery is readability, and CTE is almost always more readable.
In this case however.... since he's creating a CTE and just selecting from the CTE with no joins or anything, it seems like overkill.
 
This is why I hate SO. You think we have a voting problem......
I can not flag this as a duplicate, because this answer does not yet have an upvote. — ckuhn203 30 secs ago
 
A CTE/subquery will generally perform better than a temp table or table variable because temp tables and table variables have to first be created and filled.
 
0
Q: Adding file name information to CSV file columns

Jerry SweetonIs there a simple way to combine the functions of this Powershell script? It would be nice to have it file to one output file instead of several output files. GET-DATE WRITE-EVENTLOG -logname Application -Source BLERG -EventID 1000 -entrytype Information -message "START CBM_PARSE.ps1" -cate...

 
Hey Alex
 
@ckuhn203 The mark as duplicate is for marking a question as a duplicate of another answered question... if the question has no upvoted answers, it's not answered.
 
5:30 PM
@rolfl thanks a lot
 
I believe you have a new job in Romania.
 
just one thing: bluebug's quote was slightly off, I did not use the word "kindly", it's something that I do not use, but know that I meant the same thing
 
@nhgrif I know that.
 
looking back I was really acting like an idiot
 
But the question is answered.
 
5:31 PM
Good luck with that, (the new job).
 
thanks, I'm having a lot of fun at it
 
But no one on SO votes either.
 
But it's note answered. If you want to mark it as a duplicate, then upvote one of the answers to that question.
 
At least not in my little "community" of it.
 
these past 100 days I've spent a lot of time with people way out of my league and learned a lot, both on the internet and at the job :)
 
5:32 PM
You can upvote before you can close vote.
 
so I guess at the same time I have to thank you for the ban ha
 
@AlexM. - you did ask for it.
 
I guess that's true lol
 
And if you don't know enough about the question/answer to know whether or not the answer is worth an upvote, then how can you know that the other question is a duplicate?
 
anyway, I'm off now, thanks again :D
you're awesome
 
5:33 PM
Look, @AlexM. - I have to run (talking with others about this has made me late).
It's good to have you back, but you should know that your leash is short.
 
nah I'm sure I won't need to cause problems ever again
no worries
 
Time to plunge in to the cold wateers of lake huron.
 
I've gotten good at not allowing myself to
have fun
 
@nhgrif The "answer" was mine. The other answer was not worthy of an upvote. I wasn't about to upvote something that didn't deserve it.
I can't upvote my own answer.
 
Oh, I see. Well I upvoted the answer anyway.
 
5:34 PM
Thank you.
 
Didn't catch that it was your own answer.
 
Yeah. Sorry.
There's another one somewhere. I'll have to try to find it and mark it when I have a sec.
Thanks a million.
 
@rolfl you unbanned him?! WHAT HAVE YOU DONE?! chuckels I was tentative about it. hehe. I think we might need you again soon. lol.
 
I've never been to this chatroom before huh
 
5:53 PM
0
Q: Firefox says could not download the opensearch plugin

Jason NicholsNote: xPost from SO here. Might be more appropriate here. Backstory: I'm trying to dynamically generate a search plugin for Firefox based on user entered values. I'm not including the forms and cruft surrounding it, because I've narrowed it down to a simple failing test case trying to import any ...

 
@nhgrif and @ckuhn203 you can't say a question is a duplicate of a question with out any answers. does that make sense?
what questions are we talking about?
 
6:10 PM
Is the community challenge still active?
 
This one?
28
Q: Let the CR Games begin!

Mat's MugJune is about to end. Summer's here (well, if you're in the northern hemisphere, that is.. otherwise, ... yay, winter!), and with it, vacations. We need a new community-challenge. Let's play. I mean, let's find a game to play. The game... Has to revolve around reviewing code, or posting code ...

 
Yep, this very one :)
 
Yeah. I just saw some new questions over the weekend.
 
Great. I may soon submit a related question.
 
Awesome. I ended up answering my own. What's your poison @Morwenn?
 
6:22 PM
0
Q: Refactoring fat ASP.NET MVC Controller

marinI have just began porting an old project to ASP.NET MVC . In the end, I'll have a lot of controller methods like the one below, called by AJAX requests done by JQGrid objects in the pages: AJAX request: /UserRole/RolesByUserGridData?userId=2&_search=false&nd=1407171194811&rows=10&page=1&sidx...

1
Q: My implementation of the repository pattern

JamieI'm using this pattern since a few months and I was wondering if I can make it any better. The one thing I am not satisfied about is the dispose method. In every repository I have to add a dispose method that calls the base dispose method. Is there a way to get rid of the dispose method in every...

 
6:51 PM
2
A: Generating Cartesian product of strings in R

Sven HohensteinYour approach is an example of good R code. However, there is a base function that allows creating a cartesian product of strings, interaction. This function creates a factor, and the levels are equivalent to the cartesian product. Furthermore, instead of paste(..., sep = "") you can use paste0(...

this answer by a newcomer deserves more upvotes, you can tell even if you don't speak R
 
7:03 PM
ho ho ho
 
Santa, is that you? :)
2
 
7:25 PM
@Mat'sMug talking about you on Meta. meta.codereview.stackexchange.com/q/2213/41243
 
0
Q: General select statement to stored procedures

shaftutI'm trying to write a general function to several specific stored procedures but I'm afraid that it will cause errors that I don't see now. The function get a the name of the stored procedure as a string and get a list of object that contain the parameters of the stored procedure. Is it looks goo...

0
Q: Non recursive lambda evaluator that "magically" optimizes tail recursion

jsoldiI think pasting my main method GetTermValue plus the StackFrame class and a couple of helper methods (Return and Replace) should be all I need to keep it concise, but first a few notes about the code: An ILambdaValue represents a value that is basically the result of evaluating an ILambdaTerm, w...

 
1
Q: Why doesn't this user have a bronze tag badge?

ckuhn203Mat's Mug has a score of 154 on 35 non-wiki answers for vba, but he's not recieved a bronze tag badge. Why is that? I thought the requirements were a score of 100 on 20 non-wiki answers.

 
Forever sad. I thought I was getting close to one.
 
Sorry. :-( I guess it won't be getting 31 more question anytime soon, either.
 
7:40 PM
Probably not. We have to close most of the questions we do get. It's ok.
I'm real close to , so that's a consolation.
 
I'm only three questions and three upvotes away from gold. Gotta stay patient.
2
 
@CaptainObvious I don't see any SQL in that question...
 
Mat will go straight to silver by time is eligible for a badge. lol
@Phrancis He's passing in a string representing a sproc name.
 
That sounds dirty @ckuhn203
 
0
Q: Attempting to Run Loop in Mathematica

user18972I am currently attempting to run a loop in Mathematica which will attempt to insert in position {i,4} of the date list the day of the week by int. For some reason this seems to only work work for i=1 and then fails to continue. Below is the code. For[i = 2, i < n + 1, i++, If[date[[i, 3]] == d...

 
7:57 PM
@Phrancis I'm not sure to be honest. Doesn't sound too terrible.
At least he's not concating sql strings
2
 

« first day (457 days earlier)      last day (3563 days later) »