Posts

stored procedures - Sql Server: Compare multiple dates, remove duplicates and add new column all in one -

what best solution following problem? so have stored procedure inserts temporary table information so: id | name | date | age | bin |status| description | warn1 ----------------------------------------------------------------------- 01 | abcd |2016-01-01 15:00:00| 17 | 0 | 40 | done | 0 01 | abcd |2016-01-01 11:00:00| 17 | 0 | 30 | waiting | 0 01 | abcd |2016-01-01 10:00:00| 17 | 0 | 10 | started | 0 02 | zxcv |2016-01-02 11:30:00| 18 | 0 | 35 | error | 0 02 | zxcv |2016-01-02 11:00:00| 18 | 0 | 30 | waiting | 0 02 | zxcv |2016-01-02 10:00:00| 18 | 0 | 10 | started | 0 03 | yttr |2016-01-02 12:30:00| 16 | 0 | 30 | waiting | 0 03 | yttr |2016-01-02 10:00:00| 16 | 0 | 10 | no desc | 0 04 | huuo |2016-01-02 11:30:00| 17 | 0 | 40 | done | 0 04 | huuo |2016-01-02 09:00:00| 17 | 0 | 30 | waiting ...

jquery - Two animation to fadeIn at the same time? -

i'm trying 2 animations fadein onto screen @ same time. impossible because 1 animation waiting until 'typed.js effect' finish before counting animation-delay. so in order have 2 animationsfadein @ same time have set different animation-delay. the jsfiddle shows problem: https://jsfiddle.net/harrydry/p4ev1nj2/13/ merely setting animation delay 2 different types come on in sync not solution. whole animation far more complex , won't work. have used css animations plugin shown here: <span class="line1 animated fadein">jim jarmusch</span> if jquery fadein() option, can use common class selector , animation simultaneous: html <div style="display:none" class="test"> test 1 </div> <div style="display:none" class="test"> test 2 </div> <div style="display:none" class="test"> test 3 </div> <div style="display:none" c...

html - SVG changes color when rotated in Safari 10 -

Image
i've run weird problem shows in safari 10. have playing cards, svg images, rotated using transform:rotate(xdeg) . the card i'm using has red block pattern. when it's not rotated, or rotated @ right angles, i.e. 90, 180, 270, looks normal. but, other angle , background pattern turns blue! got report 1 of users , have never seen weird. other browsers work normally, safari 9 normally. i'm guessing weird bug in safari 10, ideas how work around it? i've created minimal repro at: https://jsfiddle.net/2zv4garu/1/ weird bug indeed. performing transformation in wrapping g element svg transform not resolve issue. however, performing 3d rotation instead of of 2d one, i.e. inlinecard.style.transform = 'rotate3d(0,0,1,' + e.currenttarget.value + 'deg)'; resolve issue, can see here. https://jsfiddle.net/qe00s1mg/

Information about rabbitmq delayed-exchange -

we using rabbitmq-server_3.5.7 , corresponding delayed-message-exchange plugin until using direct-exchanges , controlling delays on message-producers on client applications (and keeping track of number of messages in queue). we have started using delay-exchanges successfully, wondering how check number of messages delayed (this is, awaiting routed queue). does rabbit provide way of knowing this? there other method access information? thanks! sorry, should've searched better before posting. basically, looking through closed issues in repo: https://github.com/rabbitmq/rabbitmq-delayed-message-exchange/issues/3 it's stated functionality available in release 3.7.0 (at time of writing it's still 3.6.6)

sidewaffle - TemplateBuilder _preprocess - generate new guid as value -

i using sidewaffle templatebuilder create multi project solution. in 1 of projects have guid change during _preprocess generating new guid in place. like: add key="base(new guid(&quot;{34bc9328-fc0d-4960-83b2-612b13de1514}&quot;))" value="base(new guid(&quot;mynewguidhere&quot;))"/> how can done? of course, after posting question, new angles , testing. found answer. easier 1 think. there mechanisms doing built in template generation. more info on them check here template parameters. but in short can use $guid1$ $guid10$ getting 10 unique guid's. in _preprocess file: <add key="base(new guid(&quot;{34bc9328-fc0d-4960-83b2-612b13de1514}&quot;))" value="base(new guid(&quot;$guid1$&quot;))"/> it simple :)

javascript: what is this: (function(args){})(moreArgs){}); -

this question has answer here: what (function() { } )() construct in javascript? 18 answers am still , again , forever trying come grips javascript. @ other scripts inspiration , learning. know is: (function(args){})(moreargs){}); it's skeleton of jquery. can explain me how works? thanks! here more of skeleton: ( function( global, factory ) { } )( typeof window !== "undefined" ? window : this, function( window, noglobal ) { return jquery; } ); tldr; (func)(params); executes function inplace out having assign function separate variable. lets break code down it's smaller elements. firstly whole code self executing function. consider have anonymous function. var add = function (a,b) { return + b; }; we can call function like add(1,2); however can wrap our function in () , call in same way. (add)(1,2); both res...

sql server - SQL - generate a list of cheapest options -

the schema little bit strange. have 2 tables: create table [dbo].[events]( [id] [int] not null, [name] [varchar](50) not null, [venueid] [int] null ) create table [dbo].[venues]( [id] [int] not null, [name] [nvarchar](50) not null, [averageprice] [int] not null ) and data this: insert venues (id, name, averageprice) values (1, 'arena1', 100), (1, 'arena2', 200), (1, 'arena3', 50), (2, 'club1', 50), (2, 'club2', 150) insert events (id, name, venueid) values (1, 'consertatarena1', 1), (2, 'consertatarena2', 1), (3, 'consertatarena3', 1), (2, 'conference', null) i need produce: 'consertatarena3', 'conference' . cheapest venue option events same venueid plus events null venueid. tables quite massive, few million rows. efficient select it? the database sql server 2012 standard. it looks have problem in way store data. in example ...