R Programming-Find Mean, Complete Cases, And Correlation of Pollutants in File Data

In this post, I am going to show functions that l have written to work on a data in files which contain observation of pollutants monitored at different locations. The data is a .csv file and there are 332 monitors which are set up at different locations. Sample of data looks like below “Date”,”sulfate”,”nitrate”,”ID” “2003-01-01”,NA,NA,1 […]

Read More

What difference does it make when you write SQL Stored Procedure with or without Begin and End?

Remember those college  days when your calculus professor will ask questions such as prove  that cosine 90 is zero?  No? Ok, take it easy, its not coming back to haunt you anymore. Have you ever thought writing SQL stored procedure with or without Begin End will execute differently? To be frank, I have never thought […]

Read More