Groups > microsoft.public.sqlserver.programming > #31289

Interpreter supports single select

X-Received	by 10.13.213.208 with SMTP id x199mr13514559ywd.48.1455898122301; Fri, 19 Feb 2016 08:08:42 -0800 (PST)
X-Received	by 10.50.66.236 with SMTP id i12mr254003igt.7.1455898122215; Fri, 19 Feb 2016 08:08:42 -0800 (PST)
Path	csiph.com!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!peer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!border1.nntp.dca1.giganews.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!w104no2126203qge.1!news-out.google.com!l1ni18647igd.0!nntp.google.com!hb3no7136585igb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	microsoft.public.sqlserver.programming
Date	Fri, 19 Feb 2016 08:08:41 -0800 (PST)
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=98.101.188.202; posting-account=FQgZ0gkAAABWW0jpbtz2W3r1Vw-e6I9t
NNTP-Posting-Host	98.101.188.202
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<97015ec1-d2aa-471c-813a-c14b036acd14@googlegroups.com> (permalink)
Subject	Interpreter supports single select
From	Jack Brosch <jbrosch58@gmail.com>
Injection-Date	Fri, 19 Feb 2016 16:08:42 +0000
Content-Type	text/plain; charset=ISO-8859-1
Lines	18
X-Received-Bytes	1468
X-Received-Body-CRC	4255000702
Xref	csiph.com microsoft.public.sqlserver.programming:31289

Show key headers only | View raw

I'm working through a SQL interpreter that only allows one outer select command (sub-queries / unions are supported) and I'm trying to work around this ... any suggestions?

-- Works
Select *
	INTO TempJack
	FROM Sales.Customer

Select *
	From TempJack



-- Doesn't work
SELECT * FROM 
	( 
	SELECT * 
		INTO TempJack
		FROM Sales.Customer
	)

Back to microsoft.public.sqlserver.programming | Previous | Next — Next in thread | Find similar

Thread

Interpreter supports single select Jack Brosch <jbrosch58@gmail.com> - 2016-02-19 08:08 -0800
  Re: Interpreter supports single select Erland Sommarskog <esquel@sommarskog.se> - 2016-02-19 21:44 +0100

csiph-web