hrbrmstr

library(RCurl)
library(XML)
library(plyr)

#' get the Qualys SSL Labs rating for a domain+cert
#' 
#' @param site domain to test SSL configuration of
#' @param ip address of \code{site} (will resolve it and take\cr
#'  first response if not specified, but that may not always work as you expect)
#' @param hide.results ["on"|"off"] should the results show up in the SSL Labs history (default "on")

IronistM

set RecCount = 500000000; // Number of records to generate  

Data: 
load  
    chr(round(25 * rand() + 65)) & chr(round(25 * rand() + 65)) & chr(round(25 * rand() + 65)) as Customer, // Customer name between AAA and ZZZ  
    chr(round(25 * rand() + 65)) as Product,                // Product name between A and Z  
    round(3 * Rand() + 2008) as Year,                  // Year between 2008 and 2011  
    round(1000000 * Rand()) as Actual,                  // Actual Revenue between 0 and 1,000,000  
    round(1000000 * Rand()) as Target                  // Target Revenue between 0 and 1,000,000 
autogenerate(RecCount);

IronistM

let vLastMonth = Year(AddMonths(now(),-1)) & '-' & num(month(addmonths(now(),-1)),'00') & '-01';
// This gets the first of the previous month
let vThisMonth = Year(now()) & '-' & num(month(now()),'00') & '-01';
// This gets the first of the current month

ODBC CONNECT TO MyDSN; // Change to your database

LOAD *;

SQL SELECT