|
From: Robert M. <rob...@gm...> - 2013-01-23 00:46:48
|
What does the error message look like ?
Rob
On Tue, Jan 22, 2013 at 7:29 PM, <thv...@co...> 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
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>
|
