mysql - Is this a t sql stored proceedure -
i want execute within excel (sql query window) execute select statement. should make stored proceedure , execute tat within excel?
begin try drop table globalshop.dbo.v_order_hist_dtl_quote end try begin catch end catch begin try drop table globalshop.dbo.v_order_lines_quote end try begin catch end catch select * globalshop.dbo.v_order_hist_dtl_quote globalshop.dbo.v_order_hist_dtl isnull(user_3,'') <> '' select * globalshop.dbo.v_order_lines_quote globalshop.dbo.v_order_lines isnull(user_3,'') <> '' /* quotes orders 1.0 */ select qt.quotenum, qt.custid, qt.qcustnum, qt.qcustname, qt.qdate, count(ol.order_no) #_open_orders, count(oh.order_no) #_closed_orders "track quotes".dbo.trackquoteshist qt left outer join globalshop.dbo.v_order_hist_dtl_quote oh on qt.quotenum = oh.user_3 left outer join globalshop.dbo.v_order_lines_quote ol on qt.quotenum = ol.user_3 qt.qdate between '03/01/2015' , '03/06/2015' group qt.quotenum, qt.custid, qt.qcustnum, qt.qcustname, qt.qdate
if want run select statements of time make drops 1 stored procedure (if ever want it) , select another.