Re: View to create a PF?

On 23 Aug 2013 06:18, Hoteltravelfundotcom wrote:

How do you refer to a Temp table on the i? this is not accepted:

SELECT *
INTO astccdta.#acbalmpk
FROM
(
SELECT LMLTPC
, COALESCE(IRLOC1,'') as IRLOC1
, COALESCE(IRLOC2,'') as IRLOC2
, COALESCE(IRLOC3,'') as IRLOC3
, IRPRT#
, IRQOH#
, IRWHS#
, '' as IEPRT#
, '.00' as IEQOH#
, '' as IELOC1
... /* <ed> indicate continuation */
) AS c_name /* <ed> concluded as one table-reference */

Somewhat moot to reply to this message because the direction of the issue since was put in the correct trajectory, but still I offer:

The "SELECT ... INTO" syntax is not what is desired there; others have already explained. The intention appears instead, to be to effect an INSERT INTO statement.

The table-reference as an implied temporary table [as a derived table expression, in parentheses, aka Nested Table Expression (NTE); although per query rewrite, may not be implemented as a temp table] is properly written; albeit I added the ellipses, the closing parenthesis, and the AS correlation-name to make the reference appear more complete. The table-expression optionally could be preceded by the keyword TABLE or LATERAL to provide emphasis or to change the available scoping of correlated names if required.