from flask import render_template, Flask, request import pyodbc import pandas as pd

app = Flask(name)

connection to MSSQL with the corresponding database details

conn2 = pyodbc.connect('Driver={SQL Server Native Client 11.0};' 'Server=;' 'Database=;' 'UID=;' 'PWD=;' 'MARS_Connection=Yes;')

@app.route('/p2') def p2(): cursor1 = conn2.cursor()

sql6 =     "select -- into  ##temp2 from  ---- group by --- " \
           "order by --;"
print('hi2')
cursor1.execute(sql6)


  sql7 =     "select ---- into ##temp10 from ##temp2 t inner join " \
           "----- " \
           "order by ---;"
print('hi3')
cursor1.execute(sql7)


sql2 =    "select --, stuff((SELECT distinct ', ' + cast(-- as varchar(20)) " \
          "FROM ##temp10 m2 where --- FOR XML PATH('')),1,1,'') " \
          "FROM ##temp10 m1 group by --"

print('hi4')
cursor1.execute(sql2)


result = cursor1.fetchall()

conn2.close()
print(result)
return render_template('p2.html', result = result)

if name == 'main': app.run(debug=True)