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
@location nvarchar(10)
AS
SELECT CustomerID as KEYID, Contactname as Lname
FROM CUSTOMERS
WHERE ADDRESS like @location
SELECT fax as fax, region as region
FROM CUSTOMERs
Thanks for all your help in advance!
Thanks & Regards,
Manasa.
Edited by: Manasa Reddy on Apr 22, 2009 8:49 PM