For last, I used to write store procedure, trigger in SQL Server 2000. And now I want to move store procedure code, trigger code and implement it into EJB technology. Can you help me how to do it ?. Thanks a lot.
I read Sun EJB Tutorial, but you know that you can create temporary table and you can use cursor in store procedure. For example with code of SP CREATE TABLE #TempTable( CustomerID int, TotalMoney numeric) INSERT INTO #TempTable SELECT a.CustomerID, SUM(a.Total1) FROM table1 a GROUP BY a.CustomerID INSERT INTO #TempTable SELECT b.CustomerID, SUM(b.Total2) FROM table1 b GROUP BY b.CustomerID UPDATE #TempTable SET TotalMoney=0 WHERE CustomerID<=0 SELECT CustomerID, TotalMoney FROM TempTable GROUP BY CustomerID I want to how to write similar code which can do it in EJB. Thanks for your attention.