... darkrealms ...

Forums before death by AOL, social media and spammers... "We can't have nice things"

comp.databases.ms-sqlserver

Notorious Rube Goldberg contraption

19,505 messages

[ << oldest | < older | list | newer > | newest >> ]

Message 19,116 of 19,505

Raul Rego to All

SELECT output goto Excel or to an SQL Vi

28 Oct 14 03:12:07

   From: rrego@pmchnnj.org   
      
   In SQL Server Manager Studio - 2014 if relevant - can I have the output of   
   this statement to Excel or a table view.  How?   
   thanks,   
   Raul   
      
   use njpies2012   
   go   
   SELECT ToxPat.CaseNumber, ToxPat.StartDate, ToxExpSub.SubDesc   
      
         , ToxExpSub.SubPoisindexCode, CodeValue.CodeValue as 'Call Type'   
   from ToxExpSub   
      
   join Toxpat   
        on ToxPat.CaseNumber = ToxExpSub.CaseNumber   
   join CodeValue   
        on codevalue.CodeID = toxpat.calltype   
   where exists (   
        select 1 from ToxExpSub x   
        where x.SubPoisindexCode = 6931087   
          and x.CaseNumber = ToxPat.CaseNumber   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)

[ << oldest | < older | list | newer > | newest >> ]