INSERT results into new table

Question

Is it possible to INSERT the result of the following query into new table

SELECT
    O.[full name], 
    O.[EID], 
    O.[Loc],
    GL.*
FROM 
    [dbo].[team] O 
OUTER APPLY 
    [dbo].[fngetlocdetail] (O.[eWorkCity]) GL

As standalone it works but I cannot INSERT results these results into a new table. Please guide. Thanks

How did you try inserting ? post that as well. What are the columns `[dbo].[fngetlocdetail]` will return ? — Pரதீப், Jan 14 '17 at 02:03
Can you post the `Insert` query you have tried and the error message — Pரதீப், Jan 14 '17 at 03:23

Gordon Linoff · Answer 1 · 2017-01-14T02:18:44.247

3

Just use into:

select O.[full name], O.[EID], O.[Loc], GL.*
into #NewTable
from [dbo].[team] O outer apply
     [dbo].[fngetlocdetail](O.[eWorkCity]) GL;

You should specify the column names for GL. As @Prdp aptly points out, this will fail if the column names in GL duplicate one of the other names.

edited Jan 14 '17 at 02:18

answered Jan 14 '17 at 01:36

Gordon Linoff

This may throw error if `[dbo].[fngetlocdetail]` returns same column name as the ones present in column list. But the possibility is very less just a information to OP. – Pரதீப் Jan 14 '17 at 02:06

score 0 · Answer 2 · edited Sep 06 '17 at 17:23

0

Did you try to use the Select Into statement?

SELECT 
    column_name(s)
INTO newtable [IN externaldb]
FROM table1;

edited Sep 06 '17 at 17:23

Eli

answered Jan 14 '17 at 01:37

GantTheWanderer

2

Why dont you add that error message so we can see it and help instead of just vaguely referencing the failure – GantTheWanderer Jan 14 '17 at 03:21

2 Answers2