Archives For wvpv

joe-bill-spriggs2

Joe Bill Spriggs, Bloomington High School, Bloomington, Indiana (ca 1928-1931)

Found this picture of my Granddad (1913-1985) when going through photo albums after my Grandmother died back in October.

Grandmother told me he played against John Wooden from Martinsville, IN in the late 1920′s.

If anyone knows his FT%, please let me know.

Persistence

5/14/2013 — Leave a comment

via Tastefully Offensive

via neatorama

via Devour

Suppose you’d like to select rows in an ExactTarget data extension created on the last day of the month. Here’s what I use:

select
de.createdDate
from [dataExtension] de
where 
dateadd(dd,datediff(dd,0,de.createdDate), 0) = 
dateadd(d, -1, dateadd(m,datediff(m,0,dateadd(dd,datediff(dd,0,getDate()), 0))+1,0))

The last portion of the where clause finds the first day of the next month and then subtracts one day.

Normally queries like this run in a daily automation.

For further reading: