Hacker Newsnew | past | comments | ask | show | jobs | submit | pohart's commentslogin

CTEs aren't for creating a simple value. They are for creating a table variable.


I know what CTEs are for (in practical terms they're useful for subqueries you need to reference more than once), and like I said before, you can define temporary tables with the DECLARE keyword. To give you an example, this is valid T-SQL code...

DECLARE @temptable TABLE (id INT, fulldescription NVARCHAR(MAX));


Take it, but don't stop the ruby. At this stage it is worth getting as much programming experience and direction as possible.


I agree that you can't learn to program from sitting in lectures, but they can help you. They can help especially in conjunction with well chosen programming assignments. Most programming assignments are designed to introduce you to new topics in algorithms or data-structures. This allows you to expand your abilities more quickly that you would on your own. Learning ruby simultaneously will hopefully help jmonegro learn some of the shortcomings of java. The projects probably won't be large enough for him to see many disadvantages in ruby. ruby really shines in the kind of small programs people normally write when first learning a language (among other areas).


while it's possible that mentioning it to your employer may have negative consequences, I think it much more likely that your employer will get you what you need as far as an ergonomic workspace. Unfortunately you need to have some idea of what you need in an ergonomic workspace to ask. So if you have the money, try different things at home. You may also be able to borrow coworkers items to try them. Frequently, someone who has dealt with RSI and found some simple solutions will be excited to share whatever helped them.


small mice always cause me problems


before spending $1000, adjust your chair, keyboard, and mouse so that your posture is good, your shoulders are relaxed and your wrists are in a neutral position. You may not be able to do this with a standard keyboard, but a split keyboard is less than $100. if your chair doesn't adjust, get one that does. I personally like a chair that doesn't have armrests, as they sometimes cause me to raise my shoulders or contort my wrists, and I am comfortable resting my arms on my body/legs/


I think you went to the wrong school. you should not have been doing boring monotonous busywork in any program at ANY college/university. I double majored in Economics and Computer Science, and was one credit away from a math major as well. The busy work that I did was limited to a single 400 level Economics course. The course was required for business majors, and apparently business majors at SUNY Albany were unable to perform arithmetic or even perform simple substitutions into formulas without a disgusting amount of hand holding. Other than that my education was busy work free.


While I see the point of such a thing, I don't like the idea of only reading the posts of people sharing my values/ideas. I already have my values/ideas and reading them will reinforce, instead of expand, them.


I had over half of the class accused of cheating in an undergrad class.

He let them off the first time without including the grade on that assignment, but warned that it would not be acceptable on future assignments. When people did it again they failed.

Two of them were caught cheating in another class, and attempted to withdraw after they were told they had Fs for failing. They were kicked out of school.

But it really should take less than 3 instances of cheating in class and 1 of cheating on the system to get kicked out.


I always thought this was an issue at my school. Fail the students who need to fail. Supposedly we had a rule that no more than 25% of a class should fail. I was in classes where more than that deserved to fail.

I also seriously considered dropping out when I received a D+ in a class that I felt deserved a solid F. I rarely went to class, I did none of the homework, and consequently received 3% of the total available test points.

I was also in the top half of that class. I considered dropping out because I felt my degree would be worthless if the standards were so low. Instead I started working hard and found that getting A's and B's was still appropriately difficult, even if getting a D+ was not.


My mental models for grades today: B is the median. A is above average. C means you showed up and handed things in, but didn't really "get it".

So, on this scale, D and F aren't really distinguishable. Either pretty much mean you didn't make an effort.

I've been taking CS graduate classes part time with (who I consider to be) pretty smart people, so I am happy with an A and satisfied with a B. If I try and still get a C, I'll know that I didn't really belong in that class, at least without more preparatory work.


My professor's view was also that D and F were pretty much the same also, you can't get very many Ds and stay in school. D is kind of like a "high fail." I believe we were limited in the number of Ds on our transcript for graduation, although I don't remember anymore.


I've always called those "pity passes", as in you really failed, but the prof took pity on you and bumped up your 45% to 50%.

I know that at my school I need an average of 60% to graduate with an honours degree (not that that matters, because I need a 70% average for Co-op).


Only one problem (at many places): D is no longer an acceptable grade for required classes. Where I teach (a top US university), neither is C-.

Of course, we don't want to require people to take the class again. So C is the new F.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: