Recent Articles
Force Windows 7 to open excel documents in separate windows
Force Windows 7 to open excel documents in separate windows. Share on Twitter Share on Google+ Share on Facebook Share on LinkedIn
Read Article ›SISS excel import data
Run ssis package in 32bit mode When execute dts package, run the x86 version: “C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dtexec.exe” /de test /f “\\SI-FIFA-01\SQLBackup\Script\d3reasearch\zones32bit.dtsx” other resurces: http://toddmcdermid.blogspot.com/2010/01/quick-reference-interacting-with-office.html http://36chambers.wordpress.com/2010/07/13/ssis-and-excel-on-a-64-bit-server/ Share on Twitter Share on Google+ Share on Facebook Share on LinkedIn
Read Article ›Script for bootstrapping
dato <- read.csv(“c:/april.txt”, header=T,sep=”;”,dec=”,”) accuracy <- function(x, d) return(1 -sum(dato$error[d],na.rm=TRUE)/sum(dato$player[d],na.rm=TRUE)) library(boot); set.seed(101); b <- boot(data.frame(dato$error,dato$player),accuracy, R=1000) b #plot(b) ci <-boot.ci(b,type=”bca”) str(ci) ci <-boot.ci(b,type=’bca’) ci_low<-ci$bca[1,4] # ci low limit ci_hi<-ci$bca[1,5] # ci hi limit accuracy=1-(sum(dato$error,na.rm=TRUE)/sum(dato$player,na.rm=TRUE)) result <- data.frame(accuracy*100,ci_low*100,ci_hi*100) write.table(format(round(result,2), digits=3),”c:/filename.csv”,col.names=TRUE,row.names=FALSE,sep=”;”,dec=”.”); Share on Twitter Share on Google+ Share on Facebook Share on LinkedIn
Read Article ›dayOfweek and month in english
eng_day: IIf(Weekday([daydate])=1;”Sunday”;IIf(Weekday([daydate])=2;”Monday”;IIf(Weekday([daydate])=3;”Tuesday”;IIf(Weekday([daydate])=4;”Wednesday”;IIf(Weekday([daydate])=5;”Thursday”;IIf(Weekday([daydate])=6;”Friday”;IIf(Weekday([daydate])=7;”Saturday”))))))) eng_month: IIf(Month([daydate])=1;”January”;IIf(Month([daydate])=2;”February”;IIf(Month([daydate])=3;”March”;IIf(Month([daydate])=4;”April”;IIf(Month([daydate])=5;”May”;IIf(Month([daydate])=6;”June”;IIf(Month([daydate])=7;”July”;IIf(Month([daydate])=8;”August”;IIf(Month([daydate])=9;”September”;IIf(Month([daydate])=10;”October”;IIf(Month([daydate])=11;”November”;IIf(Month([daydate])=12;”December”)))))))))))) Share on Twitter Share on Google+ Share on Facebook Share on LinkedIn
Read Article ›Microsoft Access tips: Truncation of Memo fields
Microsoft Access tips: Truncation of Memo fields. Share on Twitter Share on Google+ Share on Facebook Share on LinkedIn
Read Article ›ThrottleStop – Performance Adjustment Tool for Core 2 / Core i CPUs
ThrottleStop – Performance Adjustment Tool for Core 2 / Core i CPUs. Share on Twitter Share on Google+ Share on Facebook Share on LinkedIn
Read Article ›How to Manually Register DLL in Windows Vista | eHow.com
How to Manually Register DLL in Windows Vista | eHow.com. for lookeen outlook addin: regsvr32 “C:\Program Files\Axonic\Lookeen\redemption.dll” Share on Twitter Share on Google+ Share on Facebook Share on LinkedIn
Read Article ›SSIS File Operations – Copy File, Move File, Rename File and Delete File – Ashish’s Blog On SQL Server
SSIS File Operations – Copy File, Move File, Rename File and Delete File – Ashish’s Blog On SQL Server. Share on Twitter Share on Google+ Share on Facebook Share on LinkedIn
Read Article ›Reports on next page
1) Insert a PAGEBREAK in the report 2) onload event, add this code: If Me.[DVL_Query_Report_Application subreport].top > 5670 Then PageBreak155.Visible = True Else PageBreak155.Visible = False End If Share on Twitter Share on Google+ Share on Facebook Share on LinkedIn
Read Article ›