Table/Querry

6 Apr 2006 11:57 AM

Chris

I have created a querry and would like the result of this querry be stored in
a table --

Can someone tell me how I can accomplish this task

Here is the querry

SELECT   dbo.Copy_AFS.[CORP-NUM],
    dbo.Copy_AFS.[GL-ACCT-NUM-II-PRIN],
    dbo.Copy_AFS.[RESP-CNTR-NUM-II-PRIN],
    Sum(dbo.Copy_AFS.[CURRENT-BOOK-PRINCIPAL]) As [CURRENT-BOOK-PRINCIPAL],
    sum (dbo.current_month_09_2005.BookAmount) as [Book Amount],     (dbo.Copy_AFS.[CURRENT-BOOK-PRINCIPAL]-dbo.current_month_09_2005.BookAmount) as Diff,
    dbo.Copy_AFS.SUBSYSID

FROM dbo.Copy_AFS

LEFT JOIN dbo.current_month_09_2005

ON dbo.Copy_AFS.Key_tdm = dbo.current_month_09_2005.Key_Tdm

GROUP BY
    dbo.Copy_AFS.[CORP-NUM],
    dbo.Copy_AFS.[GL-ACCT-NUM-II-PRIN],
    dbo.Copy_AFS.[RESP-CNTR-NUM-II-PRIN],
    (dbo.Copy_AFS.[CURRENT-BOOK-PRINCIPAL]-dbo.current_month_09_2005.BookAmount),
    dbo.Copy_AFS.SUBSYSID

6 Apr 2006 12:20 PM

Tibor Karaszi

Use the INTO keyword:

SELECT col1, col2, ...
INTO #TabletoBeCreated
FROM ...

If you don't want to create a temp table, don't have the name preceded with a hash sign.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"Chris" <Ch***@discussions.microsoft.com> wrote in message
news:954FDA8C-DF43-4D12-8CDE-B8FE66559BDD@microsoft.com...
>I have created a querry and would like the result of this querry be stored in
> a table --
>
> Can someone tell me how I can accomplish this task
>
> Here is the querry
>
>
>
> SELECT dbo.Copy_AFS.[CORP-NUM],
> dbo.Copy_AFS.[GL-ACCT-NUM-II-PRIN],
> dbo.Copy_AFS.[RESP-CNTR-NUM-II-PRIN],
> Sum(dbo.Copy_AFS.[CURRENT-BOOK-PRINCIPAL]) As [CURRENT-BOOK-PRINCIPAL],
> sum (dbo.current_month_09_2005.BookAmount) as [Book Amount],
> (dbo.Copy_AFS.[CURRENT-BOOK-PRINCIPAL]-dbo.current_month_09_2005.BookAmount) as Diff,
> dbo.Copy_AFS.SUBSYSID
>
> FROM dbo.Copy_AFS
>
> LEFT JOIN dbo.current_month_09_2005
>
> ON dbo.Copy_AFS.Key_tdm = dbo.current_month_09_2005.Key_Tdm
>
>
>
> GROUP BY
> dbo.Copy_AFS.[CORP-NUM],
> dbo.Copy_AFS.[GL-ACCT-NUM-II-PRIN],
> dbo.Copy_AFS.[RESP-CNTR-NUM-II-PRIN],
> (dbo.Copy_AFS.[CURRENT-BOOK-PRINCIPAL]-dbo.current_month_09_2005.BookAmount),
> dbo.Copy_AFS.SUBSYSID