import pymssql

conn = pymssql.connect(server='db05.be4energy.com', user='be4visionadmin', password='cdg4s!fcv')
cur = conn.cursor()
cur.execute("use P1805015;")



cur.execute("""SELECT name 
            FROM sys.tables 
            WHERE name LIKE 'Data_Table_%_INV%' """)

res = cur.fetchall()

ac_sum = 0


for table_name in res:
    cur.execute("SELECT COL_SR_196620 FROM [" + table_name[0] + "] WHERE Date_and_Time='2018-07-20 11:00:00'")
    res = cur.fetchone()
    if res is not None:
        ac_p = res[0]
        ac_sum = ac_sum + long(ac_p)
        
print ac_sum
 
    

conn.commit()
conn.close()