Hi
I want insert the result of below query in one table, any idea how to achieve this?
Insert into does not work
I want insert the result of below query in one table, any idea how to achieve this?
Code:
TRANSFORM Last(Nz(RevenueInUSD,0)) AS WKRevenueInUSD
SELECT [Banker]
FROM tbl_TB INNER JOIN tbl_Weekly_Calendar ON tbl_TB.ValBookDate=tbl_Weekly_Calendar.ReportingDate
WHERE [BU]='Asia' And Year([ValBookDate])='2012' And ([Week Number]>20 And [Week Number]<26)
GROUP BY [Banker]
PIVOT [Week Number]
Insert into does not work
Code:
INSERT INTO tmp_Weekly_Dashboard_Data ([Private Banker], [Week1], [Week2], [Week3], [Week4], [Week5])
TRANSFORM Last(Nz(RevenueInUSD,0)) AS WKRevenueInUSD
SELECT [Banker]
FROM tbl_TB INNER JOIN tbl_Weekly_Calendar ON tbl_TB.ValBookDate=tbl_Weekly_Calendar.ReportingDate
WHERE [BU]='Asia' And Year([ValBookDate])='2012' And ([Week Number]>20 And [Week Number]<26)
GROUP BY [Banker]
PIVOT [Week Number]