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.


Popular posts from this blog