Notifications
Clear all
Topic starter
Hello,
I am working on a data warehouse that houses data. I would like to know what queries run in the procedure mbcxp_AgingVisit. I currently have read only and can not execute this, our support provider is very slow and i have a limited amount of time for this integration.
Thanks!
Mike
Posted : November 3, 2016 11:39 pm
From CPS 12 SP 10
USE [demo]
GO
/*** Object: StoredProcedure [dbo].[mbcxp_AgingVisit] Script Date: 11/7/2016 8:28:19 AM ***/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[mbcxp_AgingVisit]
@p_databaseName [nvarchar](255),
@p_agingDate [nvarchar](30),
@p_dateType [int],
@p_agingBucket [int],
@p_doctorID [int],
@p_facilityID [int],
@p_companyID [int],
@p_numberOfBuckets [int] = ,
@p_bucketSize [int] =
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [ServerProcedures].[ServerProcedures].[mbcxp_AgingVisit]
GO
Posted : November 7, 2016 3:30 am
Topic starter
Thanks for the response, I guess I need to rephrase the question. What I am trying to figure out is the SQL that builds the #Aging table created with the mbcxp_AgingVisit SP.
The procedure is run like this...
INSERT INTO #Aging
EXEC mbcxp_AgingVisit
@DB ,
@EndOfCurrentMonth ,
@AgingDateMode ,
0 ,
NULL ,
NULL ,
NULL ,
7 ,
30
I need the SQL that is run to do that INSERT.
Thanks Again,
Mike
Posted : November 7, 2016 3:47 am
Sorry, can't help you with that. Maybe someone else knows.
Posted : November 7, 2016 10:58 am
