Four

Posts

sql - Multiple stored procedures for a purge script? -

sql - Multiple stored procedures for a purge script? - i in process of creating purge script in vbscript, deletes records tables if more 1 month old. the criteria each table different, , there both parent , kid tables (i.e. latter dependent on former retrieving id codes , upload statuses). my question: should each delete block each table created separate procedure, including kid , parent deletions? how best , efficiently handled? a sample of sql code: delete teststaging.dbo.spindataentries teststaging.dbo.spindataentries.spindataid in (select teststaging.dbo.spindata.spindataid teststaging.dbo.spindata teststaging.dbo.spindata.uploadstatus in ('f', 'c') , lastuploaded < dateadd (m,- 1,sysdatetime())); delete teststaging.dbo.spindata teststaging.dbo.spindata.uploadstatus in ('f', 'c') , lastuploaded < dateadd (m,- 1,sysdatetime()); should each of these 2 blocks, remaining code, logged separate stored procedures, , called separat...

formatting - SAS SQL Datepart function returning odd values -

formatting - SAS SQL Datepart function returning odd values - i'm having massive problem project can't seem right. i'm trying modify info variable in datetime format. first info 30mar12:00:00:00. i've been advised utilize code below returns value 30mar60:5:30:00. want date component , have no thought how info got exported in format wasn't in microsoft access. i've tried several mods code 1 time again comes blank or sends error message. proc sql; update dataset set date = datepart(date); quit; any advice appreciated. i'm guessing variable date numeric , formatted datetime. 1 time you've carried out conversion, alter format date9. sas datetime value number of seconds since 01 jan 1960, whereas dates number of days since 01 jan 1960. both stored numbers, using right format display value key. illustration below. data _null_; a='30mar12:00:00:00'dt; b=datepart(a); c=b; format b datetime. c date9.; set b c; run; ...

javascript - Simple JQuery script animate not working -

javascript - Simple JQuery script animate not working - so created simple html page : index.html file: <html> <head> </head> <body> <div class="menu"> hello </div> <div class="test"> menu </div> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script> <script src="app.js"></script> </body> </html> here app.js file: var main = function() { $('.test').click(function(){ $('body').animate({ left: '500px' },200); }) } $(document).ready(main) i'm trying understand did wrong , seems should work.. was tried download jquery-2.1.1.min.js , work , still while clicking on menu , text not moving .. you need set position css property body in order work left . body{ position:relative; ...

java - Different Between this two method in jsp page -

java - Different Between this two method in jsp page - what difference between: this.log("log message"); and ((httpservlet)page).log("anothermessage"); ? if @ generated servlet jsp find this , page both same. here page , implicit object in jsp. generate servlet code jsp: public void _jspservice(httpservletrequest request, httpservletresponse response) throws java.io.ioexception, servletexception { pagecontext pagecontext = null; httpsession session = null; servletcontext application = null; servletconfig config = null; jspwriter out = null; object page = this; // page , same jspwriter _jspx_out = null; pagecontext _jspx_page_context = null; ... the log() method defined in genericservlet . here tomcat(apache) specific implementation of generated servlet jsp: javax.servlet.genericservlet extended byjavax.servlet.http.httpservlet extended byorg.apache.jasper.runtime.http...

reporting services - Adding First Values Grouped by ID from record set; report builder 3.0 -

reporting services - Adding First Values Grouped by ID from record set; report builder 3.0 - i have dataset beingness returned has monthly values different 'goals.' goals has unique id's , month/date values same goals. difference 1 goal doesn't have values same months other goal because might start @ later date, , want 'consolidate' results , sum them based on 'first' startbalance each goal. illustration dataset be; goalid monthdate startbalance 1 1/1/2014 10 1 2/1/2014 15 1 3/1/2014 22 1 4/1/2014 30 2 4/1/2014 13 2 5/1/2014 29 what want display these consolidated (summed) values in table based on 'first' (earliest month/year) value each goal. result like; year startbalance 2014 23 this because 'first' value goalid of 1 10 , 'first' value goalid of 2 '13' when seek grouping year(fields!monthdate.value) ...

vb.net - Visual basic membership program using select case? -

vb.net - Visual basic membership program using select case? - i writing programme asks user age , number of years have been member, trying through using select case. doesn't appear working, of ages fine if utilize checkbox veteran , should discount doesn't work. number of years have been fellow member doesn't alter price/ category, programme simple , i'm not sure why isn't working. screen shot of program:http://gyazo.com/ebab66526068f4c81a30c624aada7f7c code: public class form1 private sub btncalc_click(byval sender system.object, byval e system.eventargs) handles btncalc.click dim x integer dim y integer x = val(txtage.text) y = val(txtyears.text) select case x case <= 18 lblprice.text = ("£60") lblcategory.text = ("junior") case 19 49 lblprice.text = ("£120") lblcategory.text = ("senior") case >= 50 ...

r - Create a bivariate color gradient legend using lattice for an spplot overlaying polygons with alpha -

r - Create a bivariate color gradient legend using lattice for an spplot overlaying polygons with alpha - i've created map overlaying polygons using spplot , alpha value of fill set 10/255 areas more polygons overlapping have more saturated color. polygons set 2 different colors (blue , red) based on binary variable in attribute table. thus, while color saturation depends on number of polygons overlapping, color depends on ratio of bluish , reddish classes of polygons. there is, of course, no easy built-in legend need create 1 scratch. there nice solution in base of operations graphics found here. came not-so-good hack in ggplot based on this post kohske. similar question posted here , did best give solutions, couldn't come solid answer. need same myself, utilize r , utilize grid graphics. this ggplot hack came with variable_a <- 100 # max of variable variable_b <- 100 x <- melt(outer(1:variable_a, 1:variable_b)) # set info frame plot p <...