Stored procedures issue in universe BOXIR3.0
unable to insert two tables one at a time in a universe using below stored procedure. The database is Oracle. The same stored procedure is getting inserted in to the universe, when the database is SQL Server 2000. Is it any known issues!!
CREATE PROCEDURE sp_getcustomer_2results
SELECT CustomerID as KEYID, Contactname as Lname
WHERE ADDRESS like @location
SELECT fax as fax, region as region
Thanks for all your help in advance!
Thanks & Regards,
Edited by: Manasa Reddy on Apr 22, 2009 8:49 PM