This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I am trying to use stored procedures in my lightspeed model. It works fine for me for stored procedures which has some parameters and returns a fixed result set. But now the problem is I have a storedprocedure which creates a temp table on the fly for my own computation, the SQL script looks like this,
IF object_id('tempdb..#Temp') is not null DROP TABLE #Temp --Creating temp table to store the result set of rule engine CREATE TABLE #Temp (xPKID bigint) INSERT INTO #Temp EXEC dbo.spEngine @ReportPKID,@EmployeePkid
While drag and drop the stored procedure I am receiving the following error, Exception while processing Server Explorer drag: System.Data.SqlClient.SqlException: Invalid object name '#TempRules'.
Thanks in advance for your support.
Regards, Vijay |
|