nikhilkumarsingh

johndstein

-- Shows some helpful info about gift attributes.
-- This SQL is for SQL Server.

DECLARE @attr varchar(MAX)
SET @attr = 'Legacy Correction'

-- Overall Count
select count(*) count
from giftattributes ga
join attributetypes at on ga.attributetypesid = at.attributetypesid

johndstein

select *
from dbo.ConstituentAttributes as ca
inner join dbo.CONSTITUENT as con on ca.PARENTID = con.id
inner join dbo.attributetypes as at on ca.attributetypesid = at.attributetypesid
inner join dbo.TABLEENTRIES as te on te.CODETABLESID = at.CODETABLESID
inner join dbo.CODETABLES as ct on ct.CODETABLESID = at.CODETABLESID
where at.recordtype = 1
and at.TYPEOFDATA > 5

-- codetables will tell you the category, (Ex. Magazine) and tableentries will tell you a specific value, (Ex, Spring 05)

turbofart

#!/usr/bin/env python

"""
This Python code is based on Java code by Lee Jacobson found in an article
entitled "Applying a genetic algorithm to the travelling salesman problem"
that can be found at: http://goo.gl/cJEY1
"""

import math
import random

tinaarnoldi

SELECT     
GIFT.CONSTIT_ID, GIFT.Amount, GIFT.DTE, FUND.FUND_ID, RECORDS.FIRST_NAME, RECORDS.LAST_NAME, RECORDS.ORG_NAME, GIFT.REF

FROM         
RECORDS LEFT OUTER JOIN
GIFT LEFT OUTER JOIN
FUND INNER JOIN
GiftSplit ON FUND.ID = GiftSplit.FundId ON GIFT.ID = GiftSplit.GiftId ON RECORDS.ID = GIFT.CONSTIT_ID

WHERE     (FUND.FUND_ID = 'YOUR PROJECT ID OR FUND ID') AND (GIFT.DTE >= @Date)

jasonrudolph

# Credit http://stackoverflow.com/a/2514279
for branch in `git branch -r | grep -v HEAD`;do echo -e `git show --format="%ci %cr" $branch | head -n 1` \\t$branch; done | sort -r