Groups > comp.databases.ms-sqlserver > #1827

SELECT output goto Excel or to an SQL View Table

Newsgroups	comp.databases.ms-sqlserver
Date	2014-10-28 03:12 -0700
Message-ID	<5fb36b34-862a-46ba-a31a-26b71ee9f57b@googlegroups.com> (permalink)
Subject	SELECT output goto Excel or to an SQL View Table
From	Raul Rego <rrego@pmchnnj.org>

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

SELECT output goto Excel or to an SQL View Table Raul Rego <rrego@pmchnnj.org> - 2014-10-28 03:12 -0700
  Re: SELECT output goto Excel or to an SQL View Table Erland Sommarskog <esquel@sommarskog.se> - 2014-10-28 11:31 +0000

csiph-web