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.
Thanks for your reading. Can you show me detail of this problem ?. If you can't, can you help me to tel me the reference links which describes this problem ?
I believe Bill is not looking to call the stored procedure from an EJB but rather get rid of the stored procedure and implement the same logic in Java...