Skip to content

Instantly share code, notes, and snippets.

View taurenshaman's full-sized avatar
💤
lore:> hi knowledge

Jerin taurenshaman

💤
lore:> hi knowledge
View GitHub Profile
@taurenshaman
taurenshaman / Compare two numbers no convert
Last active September 1, 2018 04:44
compare two numbers stored as strings without converting them to double/int/float
// https://stackoverflow.com/a/14468767
var numbers = new string[] { "100" ,"200", "100.1" , "200.1" };
int N = 100;
var max = numbers.Select(n => n.Split('.'))
.OrderByDescending(p => p[0].PadLeft(N,'0'))
.ThenByDescending(p => p.Length > 1 ? p[1].PadRight(N, '0') : "")
.Select(p => p.Length > 1 ? p[0] + "." + p[1] : p[0])
.First();
@taurenshaman
taurenshaman / Append or update
Created June 14, 2013 11:37
Simple Enhancement for User's password @ FunnelWeb
【add Script0033.sql】
--add Salt field to User table
alter table $schema$.[User] add [Salt] nchar(32) null
go
【FunnelWeb.Model.Authentication.Mappings.UserMapping.cs】
Append:
@taurenshaman
taurenshaman / BrightstarDB.Jobs.sql
Last active December 17, 2015 11:59
add a prefix "Brightstar_" to BrightstarDB/BrightstarDB/tree/master/src/azure/sql/Jobs.sql and relative SqlJobQueue.cs
/**
* Creates the job queue table and stored procedures in the database
*/
DROP ROLE brightstar_role_gateway
GO
DROP PROCEDURE [dbo].[Brightstar_CompleteJob]
GO
DROP PROCEDURE [dbo].[Brightstar_GetJob]