I am new to Teradata and I am experiencing issues trying to insert data from a store proc into a temp table
The SQL I would normally use:
`CREATE TABLE #tmpTable
(
COL1 INT,
COL2 INT
……
)
INSERT INTO #tmpTable
Exec SpGetResults @Params1=1…`
What I have tried:
`CREATE TABLE #tmpBus
(
COL1 INT,
COL2 INT
)
INSERT INTO #tmpBus
CALL SpGetRecords (1)`
However, I am getting issues with syntax error mentioning it is incorrect. I tried looking online but could not find anything.