I am very new to MS SQL Server and am trying to learn how to combine window functions within my SQL query. I have two tables that I have to tie together using assoc_id and associate so that I can set the names in alphabetical order for my reports. Can someone tell me if this is the most efficient...
I'm working on a benchmarking library.
The code below is a textual serializer of a comnplex benchmark results structure (there will be more fields).
Main feature is building up the desired output format using library defined operands.
From end user point of view, it will look like this:
// ......
I am trying to create a resume app from django. I have divided the entities for resume as Resume, Experience, Education, Qualification/Skills, Reference. I have modeled the following entities as below
class Resume(models.Model):
applicant = models.OneToOneField(User, on_delete=models.CASCAD...
This code is used for accessing the server and making the Linux command to run the python script. While I am trying to make it multithreaded, how could I make sure that the next thread starts when the previously running thread is completed.
now it is working on a single thread.
class ssh:
...
Software development is a global industry, and programmers everywhere rely on Stack Overflow to find solutions to their problems. But as we’ve analyzed before, different countries use different languages and technologies.
In this post we’ll take a look at German software developers, as seen by their Stack Overflow visits. We’ll see how the programming languages and technologies they use differ from the rest of the world, and how they differ within major cities in the country. All of these analyses are of 2017 year-to-date, from January to mid-September. …
This API's aim is to return color-names for a bunch of hex colors.
Its the first time I am writing an API. And while I write lots of frontend code I rarely touched node.
I am interested in a general code review and also a API design review. I want to keep it as simple as possible: Someone with ...Right now I'm echoing HTML code in both portions of an if/else statement. I'm wondering if this is the best practice.
There is this topic at stackoverflow where a well-respected user describes something called "heredoc." However, I see some dispute in the comments with other respected authors. A...
I had a desire to make a recursive web crawler in vba. As I don't have much knowledge on vba programming, so it took me a while to understand how the pattern might be. Finally, I've created one. The crawler I've created is doing just awesome. It starts from the first page of a torrent site then t...
Basically I am made a class that settles most of the back-end work of a tic-tac-toe game.
I would like to have remarks about my general coding style and possible optimizations.
using System;
namespace TicTacToe_Game
{
public class Game
{
//The game's board itself.
//If ...
I would like to know how I could improve the regex part of this script?
I now chain 4 replace methods which is not optimal. Any ideas of other improvement I'm happy to receive.
const strings = [
"ACTUATOR-BRK",
"FLANG-SPLIT",
"O-RING",
"BOLT,M6X25MM HF",
"BOLT,M6-1.0",
"SCREW.CA...
I am trying to use pg-pool to connect to my DB and perform queries using a connection pool.
Here is how I do it, but to be sure I'm not doing it wrong, or to see if there is a better way, please review and critique my code.
var Pool = require('pg-pool');
var aggregation_pool = new Pool({
// ...
I am using VBA in Excel to remove the word NULL from cells. I have the following code:
Sub RemoveNull()
Dim c, count, r
Application.ScreenUpdating = False
count = 0
r = ActiveCell.row
c = ActiveCell.Column
c = GetLetterFromNumber(c)
For x = 1 To Range(c & Rows.count...
I am coding a simple GUI to use with system-generated Excel files. The formatting for all of these files is all the same, however they all have multiple rows that have nothing but zeros in them, so this program is designed to open the Excel file, remove the zeros, reformat and then save them in a...
This code reads in an input file that looks like this:
7f00000000000000000000000000000000000000000000000000000000000000027f00000000000000000000000000000000000000000000000000000000000000027f00000000000000000000000000000000000000000000000000000000000000020101
7f00000000000000000000000000000000000...
What difference does the below bring in terms of memory in considering the below in large scale consider if I make multiple getters.
// Scenario 1 : By not using temp var.
if(student.getId() != null){
student1.setId(student.getId())
}
//Scenario 2 : Using a temp var id
String id = student.ge...
I am reading the rust book (second edition) and currently I'm reading through the section on closures.
At the end of this section there is an exercise to extend the Cacher implementation given before. I gave it a try:
use std::cmp::Eq;
use std::hash::Hash;
use std::clone::Clone;
struct Cacher<...
What distinguishes Code Review from Stack Overflow?
Different communities have different rules to address different needs. A quick summary:
$$
\begin{array}{l|l}
\textrm{Code Review} &
\textrm{Stack Overflow} \\
\hline
\text{Open-ended questions} &
\text{Questions with a specific goal} \\
\tex...
Before you ask your question...
Understand the community
Code Review is a collection of users with different experience levels in different technologies. These users each have different time commitments and availability.
Understand that you are requesting a review, and you cannot demand one. C...
I'm new to Erlang and I'm trying to port my Project Euler solutions in C# to Erlang. I have a priority queue implementation with unit tests.
I'm wondering if I'm missing something(I probably do) if I was writing serious Erlang code.
priority_queue.hrl
-record(heap_node, { item :: any(), child...
I have a program, where the get_free function below has the most major computational cost by far, and I was wondering if there was a faster way to do it. Any feedback, regarding code quality in general or for optimizing performance is greatly appreciated.
Thanks
import numpy as np
import timeit...
An entity-framework-core tag was recently created. Tag asp.net-core was created some 8 months ago.
I can see a pattern here: do we really want a -core version of every single .net-related technology tag?
Any ideas? Reasons to keep them around?
So Im making a raffle game so when you press b you get a random name with all the information of the winner, I get the data from a SQL local server and I want to make a list of the winners so save the string data.
Here is my php to get data:
<?php
$servidor = 'localhost';
$user = 'root';...
I'm going to defend these tags, because after thinking about it, I think they do provide value.
First and foremost: .net-core is not universal. Just because something works in .net does not mean it works in .net-core, and vice-versa. These tags are two completely separate frameworks, so I agree ...
I made this game of snakes and ladders for school, and it has to have:
Multiple players
Player Names
Random Dice roll
Snakes and ladders (obviously!)
Subroutines
It is currently 124 lines, and is very repetitive. I need it to be at most 75 lines.
'''Take it in turns to roll the di...
I need to take an turn array of NSManagedObjects into a an array of it's entity [anEntity].
func convertObjectsToAnEntity(managedObjects: [NSManagedObject]) -> [anEntity] {
var anEntityObjects: [anEntity] = []
for obj in managedObjects {
if obj.entity == anEntity {
anEn...
Hi as part of my assignment I am working on a code. Even though I have completed the assignment, the direction() is just irking me. I feel like there is a better way to do it, ideally gaining on execution time or at least aesthetically !!
[The stub for my assignment contained code from my profes...
This question regards the numbers from 1 to 999. We can ignore commas, hyphens, and spaces. What I'm interested in is when and where to use the word "and".
There are a few interesting cases:
1) 20 < n < 100
Is it "twenty and one", or "twenty one"?
2) 100 < n < 120
Is it "one hundred and elev...
This is a pretty simple FizzBuzz variant. I'm more interested in my use of C (this is my first bit of C code) than I am in my actual FizzBuzz implementation, although I'm always open to suggestions.
In particular I'm pretty certain that my string manipulations are horrific, but I don't really kn...
I've written a very simple command line parser/dispatcher library. This is an extension of a previous review, in which I've refactored, found here. Basically, a user can add functions to a Cmdr struct, then invoke them using a &str. I've made the library generic so that a user can define their ow...
