Take a look this TSQL example
USE [XXX] GO SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE PROCEDURE [dbo].[Testing_XXX]
@broadcastId [int],
@XXXTemplateHtml [nvarchar](max),
@XXXTemplateText [nvarchar](max),
@XXXTemplateSubject [nvarchar](max),
@XXXTemplateEmailHeaders [nvarchar](max...
I thought of writing a utility class where I can implement patterns that are useful for day-to-day parsing of strings, without having to to import java.util.regex everywhere. So I wrote this simple class as a model.
Right now I only added two patterns, with the intention of adding more as the n...
I think I solved the following problem. However, I was wondering if there was a faster or more efficient way to solve this.
I believe the the runtime is O(n) and space is O(1) (O(256) assuming ASCII)
# Longest substring with at most 2 distinct characters
#
# Given a string S, find the length o...
Recently needed to swap keys with a colleague on the other side of the country.
This script encrypts a file using the other persons public key that is stored on github. It outputs a script that will re-generate the original message (if you have the private key).
#!/bin/bash
#
# Usage:
# ./crypt 
I wanted to take on the challenge of the classic Robot Path's problem but solve it using Pascal's triangle. The approach was generate pascal's triangle, then grab the middle element from the row. I saw the following pattern:
//where combos are on pascal's triangle:
// 1x1 grid on the 1st line ===>
I've written this Wack-a-mole like game on my iPad in the app Pythonista. Keeping that in mind, it uses a different graphic interface from the one I have usually seen used, Tkinter. I'm a beginner and this is my first major project, so any tips on how to code more efficiently and improve this pro...
our application structure is multi-tenant with database. each customer has their own database. i have store all tenant information in separate database. when user request api i need connect specific database. how to implement in spring boot. i am using mysql database. Now my api ready with single...
Here is our C++ Video Game Beginning/Character Creation, give us feedback, ideas, and suggestions.`
//Seasons Divided
#include <iostream>
#include <string>
#include <iomanip>
#include <stdlib.h>
using namespace std;
void LegalStuff();
void CompanyIntro();
void TitleScreen();
void intro();
int G...
Please help me find my mistakes.
public static void main(String[] args) {
int[][] grid = new int[10][10];
int i, j, steps;
boolean loop = true;
Scanner Input = new Scanner(System.in);
//prompt user for info
System.out.print("Please enter a list of (i, j) pairs for popu...
I am busy rewriting a large section of code that has multiple lambda expressions in that vary in complexity.
My question is regarding the naming of the parameters in these expressions.
We often see
MyList.Select (x => SomeConverter.Convert(x));
as one of the more simple options. Now my quest...
I have a situation in which I need to get the Closest road to a DbGeography Point.
This takes 5 - 8 seconds to run in some cases.
I have a Spatial_Index on the Column and I re-organised it, so it is not fragmented.
This Query is quite heavy, sometimes the CPU usage raises to 100% because of ...
I've got a program here which asks for initial ball bounce index (initial height divided by how far the ball bounces back up) and tells you the distance traveled from the first drop, until the ball is inert.
def main():
init_height = eval(input("Enter initial ball height: "))
while ini...
This (working) code is supposed to return a new array that consits of elements of both arrays that were not marked as duplicates (find duplicates in both arrys, remove such elements from both arrays and create an array from the leftovers, if any)
Is there a way to simplify this function?
functi...
I think this code has far to many if else clauses and not enough abstraction via functions. I would like to break the code down into a series of small functions, or methods if i decide to go OOP, but I'm not sure of the best way to do so. If you brilliant Pythonista's could guide me in the write ...
function uniques(array) {
var result = [], val, ridx;
outer:
for (var i = 0, length = array.length; i < length; i++) {
val = array[i];
ridx = result.length;
while (ridx--) {
if (val === result[ridx]) continue outer;
}
result.push(val);...
I am having a simple foreach where I add objects to list:
List<SoonestDrawDateModel> soonestDrawDateModel = new List<SoonestDrawDateModel>();
foreach (var item in drawDates)
{
SoonestDrawDateModel sdModel = new SoonestDrawDateModel();
sdModel.DrawDay = item;
...
My task was to write a server class, which uses select(), for a student projet.
It was working, but i'm now willing to improve it a lot, and be able to use it in other personnal projects, so any critique and improvement idea is welcomed !
Here is the main.cpp :
// example packet
typedef str...
My regex takes the form of the following:
/(\w{3}, \d{2} \w{3} \d{4} \d{2}:\d{2}:\d{2} GMT)/
And it matches all date strings with the format:
Thu, 19 Nov 2015 17:57:44 GMT
But it seems very convoluted. Is there a better / more concise regex for achieving this?
Thanks in advance!
I've taken the Codility Tape Equilibrium (like here) and I've put my code with writes to stdout:
import java.util.Arrays;
class Solution {
public int solution(int[] A) {
System.out.println("A " + Arrays.toString(A));
long minDiff = Integer.MAX_VALUE;
long[] leftSum...
I made my own realization of merge sort and I have two questions:
Is this code correct implementation of Merge sort algorithm
Is there a way to make this code better.
(defn rsort[a]
(cond
(<= (count a) 1) a
:else
(let [half (/ (count a) 2)
[lh rh] (split-at half ...
