Hi All,
I need to migrate a query similar to the below mentioned one from SQL to HANA. can somebody advice on this topic?
DECLARE @Anexo NVARCHAR(1)
DECLARE @PN NVARCHAR(15)
DECLARE @Total NUMERIC(19,6)
CREATE TABLE #tabela ( Anexo NVARCHAR(1), PN NVARCHAR(15), Total NUMERIC(19,6))
DECLARE c1 CURSOR FOR
Select 'A', CardCode, DocTotal from OPCH
OPEN c1
FETCH NEXT FROM c1 INTO @Anexo, @PN, @Total
WHILE @@fetch_status <> -1
BEGIN INSERT INTO #tabela(Anexo, PN, Total)
VALUES (@Anexo, @PN, @Total)
FETCH NEXT FROM c1 INTO @Anexo, @PN,@Total
END
CLOSE c1
DEALLOCATE c1
select Anexo, PN, sum(Total) AS Total from #tabela
Group By Anexo, PN
DROP TABLE #tabela
Thanks!