What does the error message look like ?

Rob

On Tue, Jan 22, 2013 at 7:29 PM, <thv69386@comcast.net> wrote:

Hello,

 

This is my first time using Squirrel & I have a basic question. Is there a way to submit multiple SQL queries at the same time, and have them run sequentially? For instance, I have the following three queries:

 

 

drop table bti2_enc1;


create table bti2_enc1compress as
select ef.*

from blinded.hf_f_encounter ef
where discharged_dt_tm between to_date('01/01/2010', 'MM/DD/YYYY') and to_date('09/30/2012', 'MM/DD/YYYY')
  and patient_type_id = 87;

 

select count(*), count(distinct encounter_id)
 from bti2_enc1;

 


 

Currently, I cannot submit all of this at once; when I try to do this, I get errors. I have to highlight and run the first query, then highlight and run the second query, then highlight and run the third query. This isn't so bad if it's just 3 queries, but I often have dozens of queries I would like to submit at one time.

 

Thank you,

 

Tracy


------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users