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

SELECT output goto Excel or to an SQL View Table

X-Received	by 10.66.139.169 with SMTP id qz9mr1512024pab.3.1414491128389; Tue, 28 Oct 2014 03:12:08 -0700 (PDT)
X-Received	by 10.182.20.243 with SMTP id q19mr242obe.38.1414491127494; Tue, 28 Oct 2014 03:12:07 -0700 (PDT)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!h15no682504igd.0!news-out.google.com!ks2ni4879igb.0!nntp.google.com!h15no682502igd.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Tue, 28 Oct 2014 03:12:07 -0700 (PDT)
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=96.242.58.190; posting-account=WG_AKQoAAABOEUiyIf1Ow04_BDE0XUgq
NNTP-Posting-Host	96.242.58.190
User-Agent	G2/1.0
MIME-Version	1.0
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>
Injection-Date	Tue, 28 Oct 2014 10:12:08 +0000
Content-Type	text/plain; charset=ISO-8859-1
Xref	csiph.com comp.databases.ms-sqlserver:1827

Show key headers only | 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