Insert og Select

Prøv med dette:

INSERT INTO dinTempTabel
(
    Select cnt
    from  (Select * from tblsplit where Level = 2) b
    left join (Select * from split_0 where statisticid = 2 and unitid = 4634) a
    on  a.splitid = b.splitid
    where  splitgroup_1 in
    (
        Select  splitgroup_1
        from  (Select * from tblsplit where Level = 2 and splitgroup_2 is null) b
        inner join (Select * from split_0 where statisticid = 2 and unitid = 4634) a
        on a.splitid = b.splitid
    )
    AND splitname NOT In ('Andet', 'Danske Bank') AND splitgroup_2 is null
    Order by cnt desc
)

jeg får følgende fejl:

Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'Select'.
Msg 170, Level 15, State 1, Line 16
Line 16: Incorrect syntax near ')'.

Hvis du vil lave en ny tabel, kan du bruge en select into:

Select cnt
Into MinNyeTmpTabel
from  (Select * from tblsplit where Level = 2) b
left join (Select * from split_0 where statisticid = 2 and unitid = 4634
) a
on  a.splitid = b.splitid
where  splitgroup_1 in
  (
  Select  splitgroup_1
  from  (Select * from tblsplit where Level = 2 and splitgroup_2 is null) b
  inner join (Select * from split_0 where statisticid = 2 and unitid = 4634) a
  on  a.splitid = b.splitid
  )
  AND splitname NOT In ('Andet', 'Danske Bank') AND splitgroup_2 is null
Order by cnt desc


Hvis du har en tabel, som kun indeholder feltet cnt, kan du gøre følgende:

INSERT INTO dinTempTabel(cnt)
Select cnt
from  (Select * from tblsplit where Level = 2) b
left join (Select * from split_0 where statisticid = 2 and unitid = 4634
) a
on  a.splitid = b.splitid
where  splitgroup_1 in
  (
  Select  splitgroup_1
  from  (Select * from tblsplit where Level = 2 and splitgroup_2 is null) b
  inner join (Select * from split_0 where statisticid = 2 and unitid = 4634) a
  on  a.splitid = b.splitid
  )
  AND splitname NOT In ('Andet', 'Danske Bank') AND splitgroup_2 is null
Order by cnt desc

lorentsnv vil du ikke sende et svar?

svar :)