import pymssql

conn = pymssql.connect(host='XXXXXX', user='xxxxxx', password='xxxxxx', database='XXXXXXX')
cur = conn.cursor()

""" itemtypenum """
cur.execute("SELECT DISTINCT hsi.itemdata.itemtypenum FROM hsi.itemdata WHERE itemdate > '2005/09/22'")
itemtypenum = cur.fetchall()

for i in itemtypenum:
   cur.execute("SELECT hsi.doctype.itemtypename FROM hsi.doctype WHERE itemtypenum=%d", i)
   itemtypename = cur.fetchone()
   print itemtypename[0]

   cur.execute("SELECT hsi.itemtypexkeyword.keytypenum FROM hsi.itemtypexkeyword WHERE itemtypenum=%d", i)
   keytypes = cur.fetchall()

   for k in keytypes:
      cur.execute("SELECT hsi.keytypetable.keytype FROM hsi.keytypetable WHERE keytypenum=%d", k)
      keyname = cur.fetchone()
      print keyname[0]

conn.close()